| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cell Background Color Depending on the Number
I recently asked a question on how to Count the days a person works even
though there is a formula in the cell and was given =COUNTIF(F4:L4,"0") By WLMPilot which works wonderfuly. Now I would like to know if there is a way for it to automaticly change that same cell with the formula in it to a specific color if a person works more than say 5 day. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Cell Background Color Depending on the Number
Select the cell with the formula.
FormatConditional FormattingCell Value is: greater than 5 Format to nice color and OK. Gord Dibben MS Excel MVP On Sun, 17 Feb 2008 16:18:01 -0800, Matlock wrote: I recently asked a question on how to Count the days a person works even though there is a formula in the cell and was given =COUNTIF(F4:L4,"0") By WLMPilot which works wonderfuly. Now I would like to know if there is a way for it to automaticly change that same cell with the formula in it to a specific color if a person works more than say 5 day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sum depending on the background color of cells in Excel? | Excel Discussion (Misc queries) | |||
| changing cell background color | Excel Worksheet Functions | |||
| Changing background color based on different cell | Excel Discussion (Misc queries) | |||
| Different background color depending on x-axis value | Charts and Charting in Excel | |||
| Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
Linear Mode
