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. ...
Ronnie_Boone What is the applied range for the CF rule. If that is $B:$B you need to use =$B1="Yes"
- 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 dataWhen you create a new rule for A2:G47, the active cell should be in row 2. I suspect that the active cell was in another row when you created the rule; that would explain the shift.
It's easiest to remove the rule and to create it again, this time making sure that the active cell is in row 2.
Ronnie_Boone Have a look at the attached file. Do the CF rules look the same as yours?
