Change Color on rows, after an IF Funtion is answered

C

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?
 
C

Cornelia

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

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
 
C

Cornelia

Thank yes this will work

Elkar said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top