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.

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.