#2
|
|||
|
|||
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.) |
#3
|
|||
|
|||
Quote:
Here is the solution I have longed for: (take a look if anyone reading my post is interested) expand_conditional_formatting.xlsx |
#4
|
|||
|
|||
Nice! Just shows to go ya that there are lots of ways to skin any particular cat in Excel.
|
Thread Tools | |
Display Modes | |
|
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 |