| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Losing Conditional Formatting after Save
I created conditional formatting for several Spreadsheets which work with no
problems until I "Save" and close a sheet. Upon opening the same worksheet later the Conditional Formatting does not apply to the sheet. I have a workaround where I open CF EditApply which applies all formatting as it should be. Why does this happen? Am I doing something wrong? Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Losing Conditional Formatting after Save
Can you upload such a file to www.filedropper.com or an other such site
? Daniel I created conditional formatting for several Spreadsheets which work with no problems until I "Save" and close a sheet. Upon opening the same worksheet later the Conditional Formatting does not apply to the sheet. I have a workaround where I open CF EditApply which applies all formatting as it should be. Why does this happen? Am I doing something wrong? Bob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Losing Conditional Formatting after Save
NO! I just asked a question. I DO NOT want to BUY anything.
"Daniel.C" wrote: Can you upload such a file to www.filedropper.com or an other such site ? Daniel I created conditional formatting for several Spreadsheets which work with no problems until I "Save" and close a sheet. Upon opening the same worksheet later the Conditional Formatting does not apply to the sheet. I have a workaround where I open CF EditApply which applies all formatting as it should be. Why does this happen? Am I doing something wrong? Bob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Losing Conditional Formatting after Save
Daniel was suggesting that you upload your file to a free site. Then you could
share the link so that others could download your file to test it. FileDropper does offer paid-for services. You don't need to use them. robert morris wrote: NO! I just asked a question. I DO NOT want to BUY anything. "Daniel.C" wrote: Can you upload such a file to www.filedropper.com or an other such site ? Daniel I created conditional formatting for several Spreadsheets which work with no problems until I "Save" and close a sheet. Upon opening the same worksheet later the Conditional Formatting does not apply to the sheet. I have a workaround where I open CF EditApply which applies all formatting as it should be. Why does this happen? Am I doing something wrong? Bob -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Losing Conditional Formatting after Save
Dave,
Thanks for the enlightenment. I'll do it. Bob "Dave Peterson" wrote: Daniel was suggesting that you upload your file to a free site. Then you could share the link so that others could download your file to test it. FileDropper does offer paid-for services. You don't need to use them. robert morris wrote: NO! I just asked a question. I DO NOT want to BUY anything. "Daniel.C" wrote: Can you upload such a file to www.filedropper.com or an other such site ? Daniel I created conditional formatting for several Spreadsheets which work with no problems until I "Save" and close a sheet. Upon opening the same worksheet later the Conditional Formatting does not apply to the sheet. I have a workaround where I open CF EditApply which applies all formatting as it should be. Why does this happen? Am I doing something wrong? Bob -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Losing Conditional Formatting after Save
O.K.
I have loaded my file to filedropper. golf2009jumpphil\smastersresultsround2 Having not used this site before, I'm not sure if I've done it correctly. My address is rgmorris at hargray.com Bob "Dave Peterson" wrote: Daniel was suggesting that you upload your file to a free site. Then you could share the link so that others could download your file to test it. FileDropper does offer paid-for services. You don't need to use them. robert morris wrote: NO! I just asked a question. I DO NOT want to BUY anything. "Daniel.C" wrote: Can you upload such a file to www.filedropper.com or an other such site ? Daniel I created conditional formatting for several Spreadsheets which work with no problems until I "Save" and close a sheet. Upon opening the same worksheet later the Conditional Formatting does not apply to the sheet. I have a workaround where I open CF EditApply which applies all formatting as it should be. Why does this happen? Am I doing something wrong? Bob -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I save formulas in conditional formatting without retyping | Excel Worksheet Functions | |||
| Need to Save File to View Conditional Formatting Changes | Excel Discussion (Misc queries) | |||
| How do I stop an pivot report from losing conditional formatting | Excel Discussion (Misc queries) | |||
| Losing links when SAVE workbook | Links and Linking in Excel | |||
| Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Hybrid Mode
