Forum Discussion
Automatic change of background color in Excel
How can I prevent the background color to change automatically when I enter an identical number in a second cell ? I tried the "no fill" but that does not work at all.
Microsoft 365 version 2608
This looks like a conditional formatting rule that highlights duplicate values. That is why choosing No Fill does not work: conditional formatting overrides the cell’s normal fill color.
Select the affected cells, then go to Home > Conditional Formatting > Manage Rules. Set Show formatting rules for to This Worksheet, find the Duplicate Values rule, and either:
- Delete the rule if you do not need duplicate highlighting, or
- Edit its Applies to range so it affects only the intended cells.
You can also select the affected range and choose Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
After removing the rule, apply No Fill again if any background color remains.
3 Replies
This looks like a conditional formatting rule that highlights duplicate values. That is why choosing No Fill does not work: conditional formatting overrides the cell’s normal fill color.
Select the affected cells, then go to Home > Conditional Formatting > Manage Rules. Set Show formatting rules for to This Worksheet, find the Duplicate Values rule, and either:
- Delete the rule if you do not need duplicate highlighting, or
- Edit its Applies to range so it affects only the intended cells.
You can also select the affected range and choose Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
After removing the rule, apply No Fill again if any background color remains.
Check (Manage Rules...)if you have this rule enabled:
You may need to check and see if you have a "conditional format" that is being copied to the cell(s)