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.