In microsoft.public.excel.misc on Mon, 20 Aug 2007, Paul Hyett
wrote :
In microsoft.public.excel.misc on Sun, 19 Aug 2007, Paul Hyett
wrote :
In microsoft.public.excel.misc on Sun, 19 Aug 2007, David Biddulph
wrote :

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

I'll try those & get back to you.

OK - that first one works!

I didn't even know about the 'Formula Is' option, before! :)

BTW, a follow-up : I'd like the cell fill colour changing only if it
wasn't empty. Presumably the 'ISBLANK' function would be involved
somehow?
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)