| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format stoplight based on worst color
Can you conditionally format based on a color? I want each row's stoplight
color (green, yellow, red) to change based on the worst color in that row. All the colors in the row are conditionally formated and will change as dates are entered or changed. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format stoplight based on worst color
How would Excel determine the "worst color"?
My wife hates red and I'm not too fond of most pastels. Your preferences may differ. Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 14:04:12 -0700, Morgimo wrote: Can you conditionally format based on a color? I want each row's stoplight color (green, yellow, red) to change based on the worst color in that row. All the colors in the row are conditionally formated and will change as dates are entered or changed. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format stoplight based on worst color
Are you being sarcastic? The color value is part of my question.
"Gord Dibben" wrote: How would Excel determine the "worst color"? My wife hates red and I'm not too fond of most pastels. Your preferences may differ. Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 14:04:12 -0700, Morgimo wrote: Can you conditionally format based on a color? I want each row's stoplight color (green, yellow, red) to change based on the worst color in that row. All the colors in the row are conditionally formated and will change as dates are entered or changed. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format stoplight based on worst color
Certainly I'm being sarcastic.
You define "worst color" please. Gord On Tue, 21 Jul 2009 14:45:01 -0700, Morgimo wrote: Are you being sarcastic? The color value is part of my question. "Gord Dibben" wrote: How would Excel determine the "worst color"? My wife hates red and I'm not too fond of most pastels. Your preferences may differ. Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 14:04:12 -0700, Morgimo wrote: Can you conditionally format based on a color? I want each row's stoplight color (green, yellow, red) to change based on the worst color in that row. All the colors in the row are conditionally formated and will change as dates are entered or changed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format color is set correct, yet color will not change | Excel Worksheet Functions | |||
| Conditional Formatting based in cell color | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Excel 2007) Format Row Color Based on X | Excel Discussion (Misc queries) | |||
| Conditional format a cell based on color of another | Excel Discussion (Misc queries) | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
Linear Mode
