[RESOLVED] Condition based on cell color

[Botillier]

I want to use an If statement based on whether or not the cell has been colored; I believe that it will look a little like this:

If (cell has interior color = true) then
Else
End if

But I am not sure what the code will be for asking VB to recognize whether the cell is colored or not.
Also could you please provide me with other good online sources for answers to questions similar the inquiry above? This way I don't have to ask so many nubi questions like this one.

[Botillier]

:blush: I am sorry the answer was previously given to me I just needed to put it together.

If ActiveCell.Interior.ColorIndex = xlColorIndexNone then

OR I could use

If Not ActiveCell.Interior.ColorIndex = xlColorIndexNone then

However, I would still like to get a hold of some recommended sources for VB code.