conditional formatting

[joe]

How can I make the color of a row automatically change based on the contents
of one of its cells.

 

[David Biddulph]

Use conditional formatting.
Use "Formula is", rather than "Cell value is".
And remember the difference between absolute and relative addressing.

 

[Bob I]

Select row and set Conditional formatting "Formula is" and then the cell
contents requirements.

 

[joe]

I did the "formula is" I just don't know what to set as the formula.

Thanks.

 

[Bob Umlas, Excel MVP]

Suppose you want the whole row to change color if the cell in G3 contains JOE:
Select the entire row, Format/Conditional Formatting, Change Cell Value is
to Formula Is, enter this formula:
=$G$3="JOE"
Click the Format button, the Patterns tab, select a color.
Bob Umlas
Excel MVP

 

[Bob I]

say A1 equal to 5 is the condition then

=$A$1=5

will be the entry

 

[joe]

Ok, I think I'm getting close. Now say I have a list that will get added to
every day and I when ever I put JOE in the G column I want that row to turn a
color.

Thanks.

 

[Bob I]

Set the formula in each row.
Row 1 is =$G$1="Joe"
Row 2 is =$G$2="Joe"
etc.

 

[joe]

Is there no faster way? We're talking dozens of lines on this list every day.

Thanks

 

[David Biddulph]

Go back and read the answers you've received.

 

[loudfish]

Highlight all the rows, make sure the activecell is in the first row,
then use a slightly different formula.

Row 1 is =$G1="Joe"

This way, Row 2 is automatically checking against G2, etc....

HTH

Andrew