Change Color on rows, after an IF Funtion is answered

[Cornelia]

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?

 

[Cornelia]

Thank you for your insite David, I have been trying to use conditional
formatting with no success and better ideas

 

[Reitanos]

Conditional formatting would be perfect for this.

 

[Elkar]

As David mentioned, Conditional Formatting is what you want here. Although,
the Excel Help isn't always that helpful. Try this:

- Select your range of data to apply the formatting to (make the top-left
cell the active cell, I'll assume cell A1 for this example)
- Select Conditional Formatting
- Use the Custom Formula: =$E1="HIGH"
- Set your color format
- Add a second condition
- Use the Custom Formula: =$E1="MEDIUM"
- Set your color format
- Add a third condition
- USe the Custom Formula: =$E1="LOW"
- Set your color format

That should do it.
HTH
Elkar

 

[Cornelia]

Thank yes this will work

As David mentioned, Conditional Formatting is what you want here. Although,
the Excel Help isn't always that helpful. Try this:

- Select your range of data to apply the formatting to (make the top-left
cell the active cell, I'll assume cell A1 for this example)
- Select Conditional Formatting
- Use the Custom Formula: =$E1="HIGH"
- Set your color format
- Add a second condition
- Use the Custom Formula: =$E1="MEDIUM"
- Set your color format
- Add a third condition
- USe the Custom Formula: =$E1="LOW"
- Set your color format

That should do it.
HTH
Elkar