Conditional Formatting Row & Text
 

I have a spreasheet with 12 coloums. The last coloum has a value of either
"yes", "no", or null. I need to conditionally format the spreadsheet so if
the value is either "no" or null the entire row is in red with a bold type
face. If the value is "yes" then the row is black and in normal type face
(not bold).

Any suggestions?
--
Clark

Conditional Formatting Row & Text
 

One way:

Select your columns (or entire sheet) with a cell in row 1 active (or
else adjust the row number, below). Format/Conditional Formatting...

CF1: Formula is =$L1<"yes"
Format1: <font/<red,bold

In article ,
Clark wrote:

I have a spreasheet with 12 coloums. The last coloum has a value of either
"yes", "no", or null. I need to conditionally format the spreadsheet so if
the value is either "no" or null the entire row is in red with a bold type
face. If the value is "yes" then the row is black and in normal type face
(not bold).

Any suggestions?