This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a large Excel spreadsheet and recently when I enter data some cells or part of cells are getting a blue background that I am not setting. Trying to se the background colour to blank will not clear it. Does anyone know what is happening and how I can clear it? I have the current Office 365 on WIndows 11, both fully updated.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
It's conditional formatting of type Data Bars.
Select the range in which this occurs.
On the Home tab of the ribbon, in the Styles group, select Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
That worked! Thanks! I have never used Data Bars and don't now how they got set.