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. ...
No, it's $A2:$G47. I used $B2 because the first row is headers.
Ronnie_Boone Have a look at the attached file. Do the CF rules look the same as yours?