Say, for argument's sake, the column of interest is Column A....

Then select the entire range to include in the highlighting event.

Go to Format|Conditional Formatting and select Formula Is from the 1st
drop down menu.

Enter formula like: =$A1=FALSE where A1 is the top-most cell in the
column of TRUEs/FALSEs.

Note the $ in front of the A, it "freezes" the Column so that all
conditions in all columns always look at column A for the conditional
request.

Then click Format and choose from the Pattern tab to complete.


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109666