Change Color on rows, after an IF Funtion is answered
 

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?

Change Color on rows, after an IF Funtion is answered
 

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?

Change Color on rows, after an IF Funtion is answered
 

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

"David Biddulph" wrote:

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?

Change Color on rows, after an IF Funtion is answered
 

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?

Change Color on rows, after an IF Funtion is answered
 

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" wrote:

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

"David Biddulph" wrote:

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?

Change Color on rows, after an IF Funtion is answered
 

Thank yes this will work

"Elkar" wrote:

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" wrote:

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

"David Biddulph" wrote:

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?