View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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.