CF/ Formula Is/ =TODAY()-A15
or
CF/ Cell Value Is/ less than/ =TODAY()-5
--
David Biddulph

"Paul Hyett" wrote in message
...
I would like to set up a conditional format whereby if today's date minus
[date in referenced cell] was greater than a certain number, then the fill
colour of the cell would be changed.

I've tried experimenting with setting this up, but just don't seem to be
able to hit the right syntax.

Any assistance would be much appreciated.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)