Forum Discussion
Conditional Formatting error
Why is it that sometimes when I enter a formula in Conditional Formatting, Excel changes it when I save it? For instance, I just entered a formula to highlight all rows that have "Yes" in column B. ...
I'm not sure anyone is understanding my question. It's not an issue of what my code is. My issue is that Excel changes it, when I save it, from =$B2="Yes" to =$B1048541="Yes". when I first create it. Then, I have to go back into the code and change it back to =$B2="Yes" before it will work.
We do understand your question; it's just that you didn't refer to the correct cell when you created the rule.