"Dave Dobson" wrote:
Wow, that is spot on!

You're welcome, Dave.

As this is a shared workbook, will the fact that it is shared prevent
anybody else from altering this CF?

Perhaps this was answered by Allllen in another earlier post?,

"Dave Dobson" wrote:
Easy when you know how! Thanks.

"Allllen" wrote:
Yes you can do it. You just need to set it up when the workbook is not
shared, then share it afterwards.

If you already have a shared file where you would like to do this, wait
until you think everyone is out of the file (you can even check it on the
sharing menu).
Then unshare it. It will save.
Then put your conditional format in place.
Then share it again and it will save again.

--
Allllen


"Dave Dobson" wrote:

It appears then, that I can not use conditional formatting in a shared
worksheet.

Is this the case?

I would like certain cells to be highlighted, based upon how far away the
date in that cell is, from today's date.

The worksheet must be shared.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---