| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to create an "average color" formula.
I am trying to create an average color. For instance I have a
-group who is red on a project -group that is yellow on a project -group that is green on a project so as a company we are yellow. I want the average color to populate as each group (team) populates their color. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want to create an "average color" formula.
Well, first you will need to decide how your colors 'average'. One way is to assign an integer value to each color, maybe something along the lines of Green = 3, Yellow = 2 and Red = 1. Then, per your example, the average of 3+2+1 is 2 and you could use Conditional Formatting to set the cell background / interior color to Yellow. It gets, however, a bit more complicated if you have two that are yellow and one that's red - the average of 2+2+1 is 1.667, so you'll have to decide what color that is supposed to be. Once you decide which value ranges map to what colors, Conditional Formatting should get you the rest of the way... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112423 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want to create an "average color" formula.
Great answer! Now how about a step by step;)
"jamescox" wrote: Well, first you will need to decide how your colors 'average'. One way is to assign an integer value to each color, maybe something along the lines of Green = 3, Yellow = 2 and Red = 1. Then, per your example, the average of 3+2+1 is 2 and you could use Conditional Formatting to set the cell background / interior color to Yellow. It gets, however, a bit more complicated if you have two that are yellow and one that's red - the average of 2+2+1 is 1.667, so you'll have to decide what color that is supposed to be. Once you decide which value ranges map to what colors, Conditional Formatting should get you the rest of the way... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112423 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "num#" errors .. how to average a group with a "num#" error | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Formula to figure an average on a range of cells with an "if" form | Excel Worksheet Functions | |||
| Can I create an "IF" function using cell color as a logical test? | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Linear Mode
