Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting for shared worksheet?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting for shared worksheet?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting for shared worksheet?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
Conditional formatting using lookup | Excel Discussion (Misc queries) | |||
Conditional formatting is unavaiable in worksheet, what can I do? | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) |