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?

 

[JenniferMurphy]

Haha. I love your avatar by the way.

Snoopy, Pogo, and Calvin & Hobbes are my favorite comic strip characters. You are probably too young to know who Pogo is.

 

[johnnyL]

Bah! I have been hornswaggled! There was no mention of Conditional Formatting, only code & the 'Font' tab. I want a refund.

 

[JenniferMurphy]

Bah! I have been hornswaggled! There was no mention of Conditional Formatting, only code & the 'Font' tab. I want a refund.

It wasn't mentioned to Alex either.

Oh, that's hornswoggled and it means cheating, which did not occur here.

 

[johnnyL]

The info you gave did not add up to your results. You left out additional info, ergo CHEAT!

LMAO, I am just messin' with ya.

#Bamboozled.