Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select colors instead of numbers for rating risk?
I want to put a color in a a column of cells from a drop down menu that pops
up when I click a cell to indicate risk-green for safe, blue, yellow orange to red for riskiest. Then I want to average the column to give me a result color. Anyone done something like that before? thx ;=) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select colors instead of numbers for rating risk?
why don't you use conditional formatting?
1: risk-safe 2 3 4 5: riskiest with conditional formatting you could then say, that each cell with a 1 has a green background (if you want to make the number invisible, select the same color for the font!) and so on. at the end you could then put the formula: =ROUND(SUM(A1:A10)/COUNT(A1:A10);0) with the same conditional formatting. hope that helps Greetings Carlo "Patrick" wrote: I want to put a color in a a column of cells from a drop down menu that pops up when I click a cell to indicate risk-green for safe, blue, yellow orange to red for riskiest. Then I want to average the column to give me a result color. Anyone done something like that before? thx ;=) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select colors instead of numbers for rating risk?
Thanks, Carlo,
I was easily able to get the cell green and the 1 invisible thanks to your guidance. I was tripped up, though, when I tried to make it red with 5. That turns off the green for a 1. Is there a way to do multiple formats for a cell using conditional formating I just don't see? Thanks again, P. "Carlo" wrote: why don't you use conditional formatting? 1: risk-safe 2 3 4 5: riskiest with conditional formatting you could then say, that each cell with a 1 has a green background (if you want to make the number invisible, select the same color for the font!) and so on. at the end you could then put the formula: =ROUND(SUM(A1:A10)/COUNT(A1:A10);0) with the same conditional formatting. hope that helps Greetings Carlo "Patrick" wrote: I want to put a color in a a column of cells from a drop down menu that pops up when I click a cell to indicate risk-green for safe, blue, yellow orange to red for riskiest. Then I want to average the column to give me a result color. Anyone done something like that before? thx ;=) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
I want to select excel cells of difference colors and increase th. | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel |