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

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

"joe" wrote in message
...
How can I make the color of a row automatically change based on the
contents
of one of its cells.

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

joe wrote:

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

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

Thanks.

"Bob I" wrote:

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

joe wrote:

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

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

"joe" wrote:

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

say A1 equal to 5 is the condition then

=$A$1=5

will be the entry

joe wrote:

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

Thanks.

"Bob I" wrote:


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

joe wrote:


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

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 Umlas, Excel MVP" wrote:

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

"joe" wrote:

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

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

joe wrote:

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 Umlas, Excel MVP" wrote:


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

"joe" wrote:


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

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

Thanks

"Bob I" wrote:

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

joe wrote:

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 Umlas, Excel MVP" wrote:


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

"joe" wrote:


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

Go back and read the answers you've received.
--
David Biddulph

"joe" wrote in message
...
Is there no faster way? We're talking dozens of lines on this list every
day.

Thanks

"Bob I" wrote:

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

joe wrote:

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 Umlas, Excel MVP" wrote:


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

"joe" wrote:


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

On 9 May, 22:26, joe wrote:

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

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