Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Change color of rows every time value in first column changes | Excel Worksheet Functions | |||
How do I change color of cells, columns and rows in Excel? | New Users to Excel | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
How do I change the color of the Rows and Coumns headings | Setting up and Configuration of Excel |