Cell / Sheet coloration wont clear.

Brian_Richmond

New Member
Joined
Apr 10, 2002
Messages
14
Hello,

I've got a slightly strange problem in which to keep the default white background from causing headaches, I selected all cells in a tab and used "Fill Color" to insert light gray. The problem is that none of the cells will accept a new fill color, nor will the "No Fill" remove the light gray that I applied. It's as if I'ved stained this particular tab in my spread sheet and can't get the stain out.

The other tabs in the workbook respond as expected using both manual, and scripted manipulations.

Any Ideas? :unsure:
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Brian_Richmond

New Member
Joined
Apr 10, 2002
Messages
14
No protection is applied, to make sure I even ran a quick and dirty activesheets.unprotect in addition to manually setting and removing protection. Still no luck, I may just have lousy Karma... hmmm.
 

Brian_Richmond

New Member
Joined
Apr 10, 2002
Messages
14
:rolleyes:

I've accidentally figured out the problem. I had a line of code for test purposes that set the print area to a single cell far off to the right most / bottom most cell of the spread sheet. The graying was covering the area excluded from the defined print area.

Thank you very much for trying to assist with this very silly :whistle: issue.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,154
Messages
5,600,024
Members
414,356
Latest member
death20

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
Top