Conditional formatting for shared worksheet?

D

Dave Dobson

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.
 
A

Allllen

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.
 
D

Dave Dobson

Easy when you know how! Thanks.

Allllen said:
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.
Click to expand...
 
Top