| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically have cell change color when a number lower than n
Hello, I was wondering if there was a formula that would make the cell change
color if a number or percentage lower than a numebr I choose is in it. For example if I have a formul to calculate the percentages of say customers happy, can I make it automatically change ot yellow if the percentage drops below 80%? Thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically have cell change color when a number lower thann
Please see "conditional formatting" in Excel Help.
ericaamousseau wrote: Hello, I was wondering if there was a formula that would make the cell change color if a number or percentage lower than a numebr I choose is in it. For example if I have a formul to calculate the percentages of say customers happy, can I make it automatically change ot yellow if the percentage drops below 80%? Thanks!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically have cell change color when a number lower than n
Use conditional formatting. Select all the cells you want to change to yellow
if <80%. Excel 2003: In the conditional formatting dialog, select the dropdown & choose Less Than, then enter .8. Click Format,click the Patterns Tab, select a yellow color. Excel 2007: Select the cells, from the Home tab click Conditional formatting/Highlight cell rules/ Less than. Then Enter .8 and if you like the choices given choose one of them, otherwise select Custom Format & proceed as in Excel 2003. HTH "ericaamousseau" wrote: Hello, I was wondering if there was a formula that would make the cell change color if a number or percentage lower than a numebr I choose is in it. For example if I have a formul to calculate the percentages of say customers happy, can I make it automatically change ot yellow if the percentage drops below 80%? Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
| Is it possible to automatically change color of cell by keying off the date? | Excel Worksheet Functions | |||
| Change text color in a cell automatically | Excel Discussion (Misc queries) | |||
| How Can i change the Color of a Cell Based on Number Value (-/+)? | Excel Discussion (Misc queries) | |||
| How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions | |||
Hybrid Mode
