ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Office 2007 Conditional Formatting question (https://www.excelbanter.com/excel-discussion-misc-queries/227056-office-2007-conditional-formatting-question.html)

robert morris

Office 2007 Conditional Formatting question
 

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 wrong?

Bob


Daniel.C[_3_]

Office 2007 Conditional Formatting question
 
Can you put the file on www.filedropper.com ?
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 wrong?

Bob





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

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