How Do I Condition A Entire Row, Based On The Content Of A Single
Hi Emmily
Select your entire block of 40 rows by 8 columns.
FormatConditional FormattingFormula Is=$H1="dog"Choose FormatOK
Substitute dog with whatever word you want.
--
Regards
Roger Govier
"Frustrated-Emmily" wrote in
message ...
Hi All
How Do I Condition A Entire Row, Based On The Content Of A Single Cell
I have a simple spreadsheet. 40 Rows long and 8 Columns wide. Column 8
(the last Column) contains a single word. Depending on what that word is,
I
want the entire row to turn into another colour.
So far. I've only managed to work out how to condition the invidual cell.
Any ideas?
Kind Regards
Emmily.
|