Use conditional formatting. Look it up in Excel help.
--
David Biddulph

Cornelia wrote:
I have a spread sheet where we track hazards.

1st column is the description of the hazard
2nd, 3rd, & 4th column are rating
4th is the total of the previous
5th Column is the If Funtion and returns with the words either HIGH,
MEDIUM, or LOW.

I would like to color code the row based on the answer in the 5th
cell.

Is there a way to do this with a Function or a Macro?