|
|
#1
05-31-2017, 11:01 AM
|
|||
|
|||
Conditional Fomatting Formats Next Cell
Conditional formatting formula: =isblank; applies to: =$Z$3:$Z$37
If any cell in the range is cleared (using delete key), the next cell in the range is formatted, not the original cell. For example, cell Z10 is cleared, cell Z11 is formatted. Why? 
|
| Tags |
| conditional formatting, formatting adjacent cell |
| Thread Tools | |
| Display Modes | |
|
|
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