Thread: [Solved] Conditional Formatting not expanding along with the table expanded
View Single Post
 
Old 10-07-2014, 07:54 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default
Quote:
Originally Posted by gebobs View Post
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.)
Thank you for your reply. I've worked around this. My first post was misleading, sorry.

Here is the solution I have longed for: (take a look if anyone reading my post is interested)
expand_conditional_formatting.xlsx
Reply With Quote