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.