Hi David

I wondered why you use days360?

Surely it would be more accurate to use
=(TODAY()-A1)365

Regards

Roger Govier


David Billigmeier wrote:
In the conditional formatting box choose "Formula Is" and enter this:

=DAYS360(A1,TODAY())365

Of course, change the 'A1' reference to whichever cell you are currently in.