Excel automatic background color

G

Guest

How do I turn off the automatic background color in Excel? Some rows need to
have a colored background to indicate that this row has been completed.
However, sometimes I want to type a note in one cell of a row and Excel will
automatically fill in the background color.
 
G

Gord Dibben

Tools>Options>Edit.

Uncheck "extend data range formats and formulas"

Or perhaps these cells have Conditional Formatting enabled?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Background stays when sorting 2
Sheet Background Color 3
Automatically color merged cells 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
background-color every second row 2
If Stmt using background color to evaluate 2
macro for copying background color 1
Gridlines over cell background color. 1

Top