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.
I know this is an old post, but I have suffered with this, but have found the answer, see here:
https://stackoverflow.com/questions/62333388/excel-conditional-formatting-formula-changes-after-i-apply-the-rule
(It's all to do with which cell is active when you enter relative cell values ie cell addresses with 1 or no $ signs)
https://stackoverflow.com/questions/62333388/excel-conditional-formatting-formula-changes-after-i-apply-the-rule
(It's all to do with which cell is active when you enter relative cell values ie cell addresses with 1 or no $ signs)