If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help, please, with unwanted fill color
Why does my entry into a cell result in an automatic fill color when the font
selection is "no fill" and no Conditional Formating rule results in that cell being filled? Thanks. |
#2
|
|||
|
|||
Help, please, with unwanted fill color
Any cell or a particular cell?
Perhaps you have some event code running in the sheet module? Right-click on the sheet tab and "View Code". Anything there? Or right-click on the Excel Icon left of "File" on the menubar and "View code". Anything there? Gord Dibben MS Excel MVP On Sat, 24 May 2008 07:50:01 -0700, SedonaBob wrote: Why does my entry into a cell result in an automatic fill color when the font selection is "no fill" and no Conditional Formating rule results in that cell being filled? Thanks. |
#3
|
|||
|
|||
Help, please, with unwanted fill color
No, there is no code. It only happens to cells in columns c,d,e and f.
Thanks, again. "Gord Dibben" wrote: Any cell or a particular cell? Perhaps you have some event code running in the sheet module? Right-click on the sheet tab and "View Code". Anything there? Or right-click on the Excel Icon left of "File" on the menubar and "View code". Anything there? Gord Dibben MS Excel MVP On Sat, 24 May 2008 07:50:01 -0700, SedonaBob wrote: Why does my entry into a cell result in an automatic fill color when the font selection is "no fill" and no Conditional Formating rule results in that cell being filled? Thanks. |
#4
|
|||
|
|||
Help, please, with unwanted fill color
All worksheets in the workbook or just the one worksheet?
ToolsAdd-ins............see any add-in there that might be doing the deed? If you don't recognize something, uncheck it and re-start Excel and open the workbook. CF, code in the workbook or an add-in is all I can think of. Gord On Sat, 24 May 2008 11:14:00 -0700, SedonaBob wrote: No, there is no code. It only happens to cells in columns c,d,e and f. Thanks, again. "Gord Dibben" wrote: Any cell or a particular cell? Perhaps you have some event code running in the sheet module? Right-click on the sheet tab and "View Code". Anything there? Or right-click on the Excel Icon left of "File" on the menubar and "View code". Anything there? Gord Dibben MS Excel MVP On Sat, 24 May 2008 07:50:01 -0700, SedonaBob wrote: Why does my entry into a cell result in an automatic fill color when the font selection is "no fill" and no Conditional Formating rule results in that cell being filled? Thanks. |
Thread Tools | |
Display Modes | |
|
|