| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color coding cells by percentage 100% = green 90% yellow etc.
need to use for visual aid on how we are doing percentagewise on usage of
time budgeted for cycle and time actually running |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
color coding cells by percentage 100% = green 90% yellow etc.
Use Conditional Formatting. Select column A Menu FormatConditional Formatting Change Condition 1 to Formula Is Add a formula of =A1=1 Click the Format button Select the Pattern Tab Select green colour OK OK Second condition Click Add Change Condition 2 to Formula Is Add a formula of =A1=.9 Click the Format button Select the Pattern Tab Select yellow colour OK OK -- __________________________________ HTH Bob "marlin svitak" <marlin wrote in message ... need to use for visual aid on how we are doing percentagewise on usage of time budgeted for cycle and time actually running |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentage of green cells in list | Excel Worksheet Functions | |||
| Confitional Formatting using (Red/Yellow/Green) for due dates | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo | Excel Worksheet Functions | |||
| Can I sort columns by colors, example - red, green, yellow | Excel Discussion (Misc queries) | |||
| How to color characters REG, GREEN, YELLOW in the same cell? | Excel Programming | |||
Linear Mode
