Conditional formatting would be perfect for this.

On Apr 28, 4:43*pm, 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?