How Do I Condition A Entire Row, Based On The Content Of A Single

[Frustrated-Emmily]

Hi All

Re: 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.

 

[Roger Govier]

Hi Emmily

Select your entire block of 40 rows by 8 columns.
Format>Conditional Formatting>Formula Is>=$H1="dog">Choose Format>OK

Substitute dog with whatever word you want.

 

[Gary''s Student]

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.

 

[Frustrated-Emmily]

Thank you both for taking the time and the trouble to post a reply.
However, I'm uncertain that I've followed your instructions correctly as it
doesn't seem to work.

From Conditional Formating in Excel 07, I choose from the drop down menu:
Use A Formula To Determine Which Cells To Format.

I then enter into the box below (where it states: Format Values Where This
Forumla Is True) the following:

=$H$1=Closed

Then I choose a colour.

Then I paste / copy this formula into all the other cells so if the word
Closed appears in Column 8, the entire row will change to the same colour.


Kind Regards
Emmily

 

[Roger Govier]

Hi Emmily

You need to enclose the test value in quotes.
You need the row reference to be Relative, not absolute as you have. Remove
the $ before the row number
=$H1="Closed"

 

[the-jackal]

Hi, Rather than start another thread about a similar thing i thought i
would use this one.

I am trying to set up a Conditional Formatting to work as follows.

If "Sat" or "Sun" is typed in any cell in column A I would like that
row to be highlighted with a colour.

For example if A10 is "Sat" cells A10 to Q10 need to be a colour.
For example if A11 is "Sun" cells A10 to Q11 need to be a colour.

Thanks in advance

Carl

;729033']Hi Emmily

You need to enclose the test value in quotes.
You need the row reference to be Relative, not absolute as you have.
Remove
the $ before the row number
=$H1="Closed"

--
Regards
Roger Govier

in
message news:[email protected]

Thank you both for taking the time and the trouble to post a reply.
However, I'm uncertain that I've followed your instructions correctly as
it
doesn't seem to work.

From Conditional Formating in Excel 07, I choose from the drop down menu:
Use A Formula To Determine Which Cells To Format.

I then enter into the box below (where it states: Format Values Where This
Forumla Is True) the following:

=$H$1=Closed

Then I choose a colour.

Then I paste / copy this formula into all the other cells so if the word
Closed appears in Column 8, the entire row will change to the same colour.


Kind Regards
Emmily

-

 

[Roger Govier]

Hi

Select cells A1:Q100
Format>from dropdown chose Conditional Formatting>Formula Is>
=$A1="Sat">Format>Choose Cell or Font colour>Add
Formula Is> =$A1="Sun">Format>Choose Cell or Font colour>OK

--
Regards
Roger Govier

Hi, Rather than start another thread about a similar thing i thought i
would use this one.

I am trying to set up a Conditional Formatting to work as follows.

If "Sat" or "Sun" is typed in any cell in column A I would like that
row to be highlighted with a colour.

For example if A10 is "Sat" cells A10 to Q10 need to be a colour.
For example if A11 is "Sun" cells A10 to Q11 need to be a colour.

Thanks in advance

Carl

;729033']Hi Emmily

You need to enclose the test value in quotes.
You need the row reference to be Relative, not absolute as you have.
Remove
the $ before the row number
=$H1="Closed"

--
Regards
Roger Govier

in
message news:[email protected]

Thank you both for taking the time and the trouble to post a reply.
However, I'm uncertain that I've followed your instructions correctly as
it
doesn't seem to work.

From Conditional Formating in Excel 07, I choose from the drop down menu:
Use A Formula To Determine Which Cells To Format.

I then enter into the box below (where it states: Format Values Where This
Forumla Is True) the following:

=$H$1=Closed

Then I choose a colour.

Then I paste / copy this formula into all the other cells so if the word
Closed appears in Column 8, the entire row will change to the same colour.


Kind Regards
Emmily

-