ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Losing Conditional Formatting after Save (https://www.excelbanter.com/excel-discussion-misc-queries/227302-losing-conditional-formatting-after-save.html)

robert morris

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



Daniel.C[_3_]

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




robert morris

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





Dave Peterson

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

robert morris

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


robert morris

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



All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com