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

  • Thread starter Thread starter Frustrated-Emmily
  • Start date Start date
F

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.
 
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.
 
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.
 
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
 
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"
 
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

'Roger Govier[_3_ said:
;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

-
Click to expand...
Click to expand...
 
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

the-jackal said:
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

'Roger Govier[_3_ said:
;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

-
Click to expand...
Click to expand...
Click to expand...
 
Back
Top