The "missing parenthesis" is just Excel's guess at what is wrong.

Your problem is you cannot specify a range of values in the If statement the
way you did. You must use the And function, as in:
=and(i11=1,i11<=60)

Regards,
Fred.

"Kanmi" wrote in message
...
=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.