Conditional Formatting help

[rodchar]

hey all,

you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the condition is
met?

thanks,
rodchar

 

[NBVC]

Can you give an example of the condition to be met?

 

[Max]

Like formulas, you can secure it with the $ sign
Eg with the entire sheet selected (A1 active)
applying CF using Formula Is: =$A1<>""
will colour entire rows where col A is not empty
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[rodchar]

For instance,

i have a column that contains 2 possible values (TRUE or FALSE)

i'd like to highlight all the rows that are FALSE by changing the back color

 

[NBVC]

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.

 

[rodchar]

Great, thanks everyone for the help,
rod.

 

[rodchar]

Thanks everyone for the help,
rod.