View Single Post
Old 04-23-2015, 07:52 PM
Bill Martz Bill Martz is offline Windows 7 64bit Office 2013
Join Date: Apr 2015
Posts: 2
Bill Martz is on a distinguished road
Default Entering a number in a cell causes it to fill with the color of a nearby cell

I have five rows of data highlighted with a light-blue fill color. If I enter a number in the cell to the right of one of the rows, in fact, either the first or second column to the right, as soon as I hit Enter, the cell is filled with the light-blue fill color. There is no conditional formatting. I didn't apply any, and I cleared all rules, anyway.

It doesn't seem to do it with all colors. If I put a number in a cell four columns over, it doesn't happen. But if I put numbers in cells in between and work my way over to the fourth column, then it will happen when I enter a number.
Reply With Quote