Conditional Formatting of a row

  • Thread starter Thread starter crap
  • Start date Start date
C

crap

I want to use Conditional Formatting to color a row (or 10 cells
across) based on the value of one cell.

If the specific cell value is "W" I want the row colored green. If it
is "D" I want the row red, and so on according to my rules.

I know it can be done 'cause I did it on an old workseet, but I don't
have it anymore.

Any suggestions?

Tx,

Ian
 
If you want A1:A10 to turn green based on a value of "W" in B1:

Highlight A1:A10 then in the conditional formating options choose
"formula is" instead of "cell value is" from the drop down menu and
enter "=$B$1="W", then choose the green background pattern.
 
Back
Top