View Single Post
 
Old 10-06-2014, 08:30 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.)
Reply With Quote