=TODAY()-A1<60

for formatting the cell entry if the date entered in A1 is less than 60
days..from today.

If this post helps click Yes
---------------
Jacob Skaria


"Kanmi" wrote:

=IF($I$11<=(1:60). please what is the missing parameter in the formular.
trying to use conditional formating to change colour if 1:60 days different
on the date entered in CELL I11. please can anybody advice on what to do.