Conditional Formatting not expanding along with the table expanded

gebobs · #1 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.)

tinfanide · #2 10-07-2014, 07:54 AM

Quote:

Originally Posted by gebobs

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

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