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)

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)

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.

Thanks.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

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! :)
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

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)

Yes. And if you are wanting to combine two functions, the AND function is
likely to be required too.
Details of all functions (except DATEDIF) are in Excel help, usually with
examples and with links to related functions through the "See also" link.
--
David Biddulph

"Paul Hyett" wrote in message
...
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)

In , Paul Hyett
spake thusly:

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?

Not a direct answer to your question, which I believe has been
answered at any rate -- but I coincidentally just finished working
out a reusable module to handle some Conditional Formatting functions.
It's working out to be rather nifty for me, so I've made a web page
about it and am happy to give away the code.

http://heliotropos.com/xl/code/cfmagic.html

=dman=