Format Row based on text value in cell

[Barnabas]

I want to format a row based on the value of one of the
cells in the row. Basically, I want to set the color of
the row to green if a particular cell in the row is
COMPLETE and red otherwise. How can I do this?

Thanks,
B.

 

[Eric]

Search for "Conditional Formatting" in Excel help.

Also, you can find help for Conditional Formatting on
Chip's website, http://www.cpearson.com/excel.htm

Hope that helps!

Eric

 

[Max]

Maybe you'll like to experiment with this as well ..

Assume the target row is row2,
the particular cell in the row is B2,
and the spec "COMPLETE"
means B2 contains the word "COMPLETE"

Select row2

Format the fill color for row2 as Red

Click Format > Conditional Formatting (with row2 still selected)

Make the settings under Condition 1:

Formula Is | =TRIM($B$2)="Complete"
Click Format button > Patterns tab > Light green > Ok

Click OK at the main dialog

 

[Max]

Just to cover a possible? lateral interpretation ..

If the spec "COMPLETE" means B2 contains "something"
(rather than the word "COMPLETE")

the lines:

Make the settings under Condition 1:
Formula Is | =TRIM($B$2)="Complete"

should read as: