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?
|