| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet cells fill with color after typing
I have a worksheet and I am only supposed to type data in un-filled (white)
cells. Other cells that are filled with light blue color are to be left blank. When I type in some of the un-filled cells and advance to the next cell for typing, the first one I typed in turns light blue! There is no conditional formatting in the cell. What could be causing some of these cells to fill with light blue color after typing in them??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet cells fill with color after typing
Perhaps an Event Macro. Right-click the tab name at the bottom of the excel
window and select View Code. -- Gary''s Student - gsnu200767 "Betsy" wrote: I have a worksheet and I am only supposed to type data in un-filled (white) cells. Other cells that are filled with light blue color are to be left blank. When I type in some of the un-filled cells and advance to the next cell for typing, the first one I typed in turns light blue! There is no conditional formatting in the cell. What could be causing some of these cells to fill with light blue color after typing in them??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet cells fill with color after typing
This isn't the case. Thanks for the suggestion, though.
"Gary''s Student" wrote: Perhaps an Event Macro. Right-click the tab name at the bottom of the excel window and select View Code. -- Gary''s Student - gsnu200767 "Betsy" wrote: I have a worksheet and I am only supposed to type data in un-filled (white) cells. Other cells that are filled with light blue color are to be left blank. When I type in some of the un-filled cells and advance to the next cell for typing, the first one I typed in turns light blue! There is no conditional formatting in the cell. What could be causing some of these cells to fill with light blue color after typing in them??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet cells fill with color after typing
Possibly ToolsOptionsEdit "Extend data range formulas and formats"
Uncheck that. Or, to follow the event code idea.........right-click on the Excel Icon left of "File" and select "View Code Anything there like............................. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) some code here End Sub Gord Dibben MS Excel MVP On Fri, 1 Feb 2008 08:13:05 -0800, Betsy wrote: This isn't the case. Thanks for the suggestion, though. "Gary''s Student" wrote: Perhaps an Event Macro. Right-click the tab name at the bottom of the excel window and select View Code. -- Gary''s Student - gsnu200767 "Betsy" wrote: I have a worksheet and I am only supposed to type data in un-filled (white) cells. Other cells that are filled with light blue color are to be left blank. When I type in some of the un-filled cells and advance to the next cell for typing, the first one I typed in turns light blue! There is no conditional formatting in the cell. What could be causing some of these cells to fill with light blue color after typing in them??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) | |||
| Can I auto fill a cell in one worksheet by typing a code number | Excel Worksheet Functions | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
| I need help getting Excel to auto-fill cells when I begin typing . | New Users to Excel | |||
Linear Mode
