ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Help, please, with unwanted fill color (https://www.excelbanter.com/new-users-excel/188748-help-please-unwanted-fill-color.html)

SedonaBob

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.

Gord Dibben

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.



SedonaBob

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.




Gord Dibben

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.






All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com