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.