cant get rid of red cell fill

keithmct

Active Member
Joined
Mar 9, 2007
Messages
254
Office Version
  1. 2021
Platform
  1. Windows
hi all,
I have a cell (A18) that continues to fill red once I type something in it seemingly without any instructions from me. There are other cells in the column which are filled red but not adjacent to this one (A1:A14 and A48:A49).
I have formatted the cell to have no fill and yet it happens again. I tried to drag the formatting from a cell below and it clears the fill but as soon as I type again it fills red!!!
What else can I do?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
ok open your VBA window (ALT+F11)

check through your worksheet for any formatting code

sorry thats all i can think off,

hope you get it sorted
 
Upvote 0
through no logical reason I have found that if I make one of the other cells in column A that are red-filled no-filled (sometimes A12, sometimes not) then it works properly.

I don't have any VBA that refers to A18.

I cleared conditional formatting from the entire sheet - I didn't have any anyway.

In between excel crashing numerous times, have had a gazillion coffees
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top