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

 

[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

 

[rodchar]

Great, thanks everyone for the help,
rod.

 

[rodchar]

Thanks everyone for the help,
rod.