Format Row based on text value in cell

  • Thread starter Thread starter Barnabas
  • Start date Start date
B

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.
 
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
 
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"
Click to expand...

should read as:
 
Back
Top