ExcelBanter - Fill colors

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fill colors (https://www.excelbanter.com/excel-discussion-misc-queries/55067-fill-colors.html)

csalger55

Fill colors

I have fill colors in some cells on my spreadsheet. When I type info in a
cell on the next row; it is putting the fill color in. I want to decide
which cells have fill color. Help.

kraljb

Fill colors

Go to Tools:Options:Edit: and unselect Extend data range formats and
formulas

--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=484425

All times are GMT +1. The time now is 04:33 PM.