leezac
asked on
Excel 2010 Conditional Formating to highlight rows based on formula
I am trying to highlight rows based on a formula using conditional formatting, but it does not seem to save the rule.
I select a range, select New Rule, enter formula and it works, but when close the file it does not save. I have read I can record a macro and use it when I want to see highlighted rows, but I want to be able to see them all the time without clicking a button.
Should the Condition Formatting disappear when I close the file, I highlight the range , enter the formula and select the formatting and I click apply and OK. Is there something I am missing when I save the Conditional Formatting maybe? When I check for the rule in Manage rules before I close the file, it shows there and is correct. Will it save if the sheet is protected?
Any suggestions would be appreciated.
I select a range, select New Rule, enter formula and it works, but when close the file it does not save. I have read I can record a macro and use it when I want to see highlighted rows, but I want to be able to see them all the time without clicking a button.
Should the Condition Formatting disappear when I close the file, I highlight the range , enter the formula and select the formatting and I click apply and OK. Is there something I am missing when I save the Conditional Formatting maybe? When I check for the rule in Manage rules before I close the file, it shows there and is correct. Will it save if the sheet is protected?
Any suggestions would be appreciated.
ASKER
Yes I see the rule under Manage Rules. I can't add file. Should it stay there when I close the file?
Yes it definitely should. Can you see it under Manage Rules when you close and open the file? Can you save other changes to the file, like regular text and formatting, and then see them when you close and open the file?
ASKER
Yes to regular changes, but could not see the Rule under Manage Rules that I saw work perfectly before I closed the file. And I know I saved the file.
Are you saving from 2010 as a .xls file? Sometimes that will loose some formatting based on what actual rules/formats you used.
There could be other things too, but hard to diagnose without seeing the file itself. Is it possible to remove or replace confidential data and attach the product?
There could be other things too, but hard to diagnose without seeing the file itself. Is it possible to remove or replace confidential data and attach the product?
ASKER
It is in compatibility mode. But when I even open it in 2010 it does not save.
Are you saving it as .xlsx file though? You need to probably because some of the conditions may not be compatible with previous versions.
ASKER
Ok I saved as .xlsx and it did retain the conditional format/ Will need to open in 2003 version also.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
NB_VC - what do you mean?
I have created a macro for the conditional formatting
I have a rule also
I have saved as xslm so I can use macros
I will be testing on 2003 later this morning.
I have created a macro for the conditional formatting
I have a rule also
I have saved as xslm so I can use macros
I will be testing on 2003 later this morning.
When you save it as a .xls file, do you get any warnings about compatibility? If so, review those warning to see which condition may not work.
i don't know about the macros... but you would need to upload a copy of the workbook (confidential data removed) for us to diagnose properly.
i don't know about the macros... but you would need to upload a copy of the workbook (confidential data removed) for us to diagnose properly.
ASKER
How do I find out how to do that?
Below the Post a Comment box, there is an Attach File hyperlink... use that to upload the file.
Can you upload the excel file here, or at least a sample?