Is interior.color different than fill?

[JenniferMurphy]

I am working on a macro to highlight cells in a large table that meet some criteria. I had it partially working but have run into a problem.

I was setting what I thought was the Fill color using statements like this:

Dim BGMax
BGMax = RGB(255, 255, 0)
Range(rnWins2).Cells(i, 2).Interior.Color = BGMax

Now that several cells are highlighted, I cannot change the background (fill?) color using the Fill dropdown.

Is interior.color different than fill?

 

[johnnyL]

Fill option when formatting cells equates to Interior.color

 

[JenniferMurphy]

Fill option when formatting cells equates to Interior.color

Then why am I not able to change that color from the sheet using the Fill menu? I can't remove the color or change it.

 

[johnnyL]

Fill menu?

 

[JenniferMurphy]

I can't minisheet because it hangs Excel. Here's the best I can do. This is a screenshot of part of the table. One of the problem cells (Y8) is selected.

If I select Y6 (75) and click on the "Fill menu" in the Font tab, I see this. Notice that the yellow color is selected. I added that fill color from the sheet.

But if I select Y8, that fill menu looks like this. The yellow color is not selected. Y8 was colored by my macro code. Something happened and now I cannot change it.

 

[johnnyL]

Sorry, I can't duplicate your issue. Could you possibly upload and provide a link to a sample file that demonstrates your issue?

 

[JenniferMurphy]

OK. I deleted everything in that workbook but the table in question. I added a text box explaining where the problem is. I uploaded it to this OneDrive folder.

Sticky Fill workbook

 

[Alex Blakenburg]

I am not at a computer at the moment but can you check the cell for conditional formatting.

 

[JenniferMurphy]

I am not at a computer at the moment but can you check the cell for conditional formatting.

Doh! I was fooling around with that several versions ago and just forgot.

Thank you. I was afraid I was going crazy. (That's still a possibility)

 

[Alex Blakenburg]

Haha. I love your avatar by the way.