|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Found answer myself: uncheck extending format in Advanced Options.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to link checkbox to change nearby cell value? | derby46a | Word VBA | 15 | 11-14-2017 01:02 PM |
If id cell range is empty then should not allow to fill any other cell | ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
Cell Fill color overwrites grid? | markg2 | Excel | 3 | 12-08-2014 09:22 AM |
Cell Background Color: Base it on Content of Cell? | tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |