Saving Cell Interior Color to a variable

[millhouse123]

I am trying to determine the color of a particular cell and then formating a respective cell in another worksheet with the same color.

I have been trying to use

Frank = WS2.Cells(X, Y).Interior.ColorIndex

This cell has conditional formatting -

using the above code returns the number -4142 as the index number when I would expect it to return 6.

Does conditional formatting effect how the line of code above would work? If so how might I solve this problem.

Thanks

 

[Domski]

-4142 is what you will get for the interior of a blank cell not one coloured yellow with conditional formatting which doesn't effect the interior colorindex of the cell.

You would basically need to test for the same logical test as the conditional formatting.

Dom

 

[VoG]

Its not that simple I'm afraid. That code is returning the manually applied color index (xlNone).

See if this helps http://www.cpearson.com/excel/CFColors.htm