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.


--
Regards,
Dave


"rsdunphy" wrote:

I need to highlite a cell that has a date and is over due 365 days or more
from todays date. Having trouble with conditioonal formatting