|
|
#2
10-06-2014, 08:30 AM
|
|||
|
|||
I'm having trouble understanding what the equation is intended to do.
=$B2:$C2=FALSE Just fiddling with it, it seems to conditionally format if, and only if, Column B is FALSE. At any rate, the equation will expand if you insert a column between B and C rather than to the right of C. Also, since you are only formatting A, I don't believe the dollar signs ($) are necessary though they should not affect the calculation. (Don't take my word on it.) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
| Conditional Formatting: How to dynamically apply to an expanding table? | tinfanide | Excel | 0 | 10-18-2013 06:34 AM |
|
Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode