|
|
#4
05-31-2017, 11:37 AM
|
|||
|
|||
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Losing Conditional Formats Upon Macro Run | Phil H | Excel | 3 | 08-26-2015 01:32 PM |
 Excel Error: “Too many different cell formats”.
|
nishant | Excel | 1 | 02-05-2014 10:50 AM |
| Too many different cell formats | nishant | Excel | 1 | 02-05-2014 10:49 AM |
|
Use formula to copy cell formats also
|
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 |
Windows XP 
Office 2010 64bit
Threaded Mode