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.

ToolsOptionsEdit.

Uncheck "extend data range formats and formulas"

Or perhaps these cells have Conditional Formatting enabled?


Gord Dibben MS Excel MVP


On Tue, 30 Jan 2007 15:06:01 -0800, Joemae
wrote:

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.