Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2015, 07:52 PM
Bill Martz Bill Martz is offline Entering a number in a cell causes it to fill with the color of a nearby cell Windows 7 64bit Entering a number in a cell causes it to fill with the color of a nearby cell Office 2013
Novice
Entering a number in a cell causes it to fill with the color of a nearby cell
 
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
  #2  
Old 04-23-2015, 07:57 PM
Bill Martz Bill Martz is offline Entering a number in a cell causes it to fill with the color of a nearby cell Windows 7 64bit Entering a number in a cell causes it to fill with the color of a nearby cell Office 2013
Novice
Entering a number in a cell causes it to fill with the color of a nearby cell
 
Join Date: Apr 2015
Posts: 2
Bill Martz is on a distinguished road
Default

Found answer myself: uncheck extending format in Advanced Options.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering a number in a cell causes it to fill with the color of a nearby cell How to link checkbox to change nearby cell value? derby46a Word VBA 15 11-14-2017 01:02 PM
Entering a number in a cell causes it to fill with the color of a nearby cell 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
Entering a number in a cell causes it to fill with the color of a nearby cell 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft