Conditional Formatting Row & Text

[Clark]

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?

 

[JE McGimpsey]

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>