![]() |
#4
|
|||
|
|||
![]()
Thanks to NBVC for the clue: the formula must refer (correctly) to the range. In this case there were two formulas for the range, one referred to Z2, the other to Z3. When the Z2 formula was changed to a Z3 reference, the problem was corrected.
|
Tags |
conditional formatting, formatting adjacent cell |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Losing Conditional Formats Upon Macro Run | Phil H | Excel | 3 | 08-26-2015 01:32 PM |
![]() |
nishant | Excel | 1 | 02-05-2014 10:50 AM |
Too many different cell formats | nishant | Excel | 1 | 02-05-2014 10:49 AM |
![]() |
mike_abc | Excel | 10 | 12-10-2011 01:55 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |