Calendar days are easy, just use

=TODAY()-A112

under formatconditional formatting formula is


Regards,

Peo Sjoblom

"ivan" wrote:

Hi,
I'm trying to use the conditional formatting feature with my Excel 2002
software for the first time, but I'm unsure of the values needed.
Here's my question.

I want a range of values (dates to be more specific) to be highlighted if
the date listed is older than 10 business days (or 12 calendar days).

I tried using the NOW, IF, and other fuctions, but didn't come across what I
wanted to do.

Any help?
Thanks