Conditional formatting for shared worksheet?

[Guest]

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.

 

[Guest]

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.

 

[Guest]

Easy when you know how! Thanks.

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.