Changing Cell Background Color Depending on the Number

M

Matlock

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.
 
G

Gord Dibben

Select the cell with the formula.

Format>Conditional Formatting>Cell Value is: greater than 5

Format to nice color and OK.


Gord Dibben MS Excel MVP
 
Top