For example, say we want row 1 to be yellow if "happy" is entered in H1.

Click on H1 and:
Format Condtional formatting Formula is

=$H$1="happy"

and pick a nice color

Finally copy H1 and paste/special/format onto A1 thru G1.
--
Gary''s Student - gsnu200805


"Frustrated-Emmily" wrote:

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.