Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO AUTO COLOR CELLS BASED ON FORMULA ANSWERS
Automating the result cell to show different colors based on answer of
formula cell. I.E. D1 is result of B1/C1. D1=100% Blue fill; 90% to 99% Green fill; less than 90% Red fill. This is a corporate dashboard. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO AUTO COLOR CELLS BASED ON FORMULA ANSWERS
Highlight column D.
Format/Conditional Formatting Cell Value is: equal to: 1 Format Patterns Blue Add Cell Value is: greater than or equal to: .9 Format Patterns Green Add Cell Value is: greater than or equal to: 0 Format Patterns Red "Merv" wrote: Automating the result cell to show different colors based on answer of formula cell. I.E. D1 is result of B1/C1. D1=100% Blue fill; 90% to 99% Green fill; less than 90% Red fill. This is a corporate dashboard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto change background of color based on formula | Excel Worksheet Functions | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
color code cells based on golddigger formula | Excel Discussion (Misc queries) | |||
color fill cells based on IF function or formula | Excel Worksheet Functions | |||
adding color to cells based on a formula | Excel Worksheet Functions |