Fill color cannot remove?

[bobkap]

I used a macro I pulled from a MrExcel book to color cells red if a certain condition was met. That worked just fine. BUT, now I want to manually change the color of a few entries. I went to the paint bucket icon on the home ribbon and selected "no fill", but nothing happened.

This is a sample of the data I have. I had to use a picture as the actual copy/paste would not show the colors.

Here's the code used to do the coloring.

'Highlight unique email addresses
With Range("C2:C566")
        .FormatConditions.Delete
        .FormatConditions.AddUniqueValues
        .FormatConditions(1).DupeUnique = xlUnique
        .FormatConditions(1).Interior.Color = RGB(255, 0, 0)
    End With

Isn't "interior.color" the same thing as what you get when you use fill colors?

 

[Fluff]

The colours are being set by conditional formatting, which overrule manually coloured cells.
To change the colour of some cells, you will need to remove the conditional formatting

 

[bobkap]

The colours are being set by conditional formatting, which overrule manually coloured cells.
To change the colour of some cells, you will need to remove the conditional formatting

Thanks very much. My real goal is to find if a certain cell has a certain color or not, but when I use this code I get the same results regardless of the color in the cell. If it's a red cell or no-fill cell, I still get the same number in return. Might you know why that happens?

ActiveCell.Interior.ColorIndex

 

[MARK858]

It is because conditional formatting doesn't come under the Range.Interior, if you are using a reasonably modern version of Excel (please consider going into your account and amending your profile to show your operating system and Excel version as it does affect whether the answers given work) then try

MsgBox ActiveCell.DisplayFormat.Interior.ColorIndex