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
is this same data you entered, because it works fine .
do you face it all workbook or this one is specific?
if it is specific then please upload sample data