Interior.Colorindex vs Conditional Formatting

[tyija1995]

Hi all,

I have made a command button that gives me a MsgBox of the active cells interior colorindex,

I notice the default is -4142.

When I make a cell yellow for example the command button returns 6

Now if I were to make the cell yellow using conditional formatting then test the command button I see -4142 again.

Is there anyway around this? Or does Excel not like this combination?

Thanks in advance!

 

[My Aswer Is This]

Cells Interior color and Conditional formatting color is not the same.

What are you wanting?
The cells Interior color or the cells conditional formatting color.
-4142 means it has no interior color.

 

[tyija1995]

The cells conditional formatting color in this case - wasn't sure if they were the same or not!

 

[DanteAmor]

If you want to know the color of a cell that has been colored by a conditional formatting then use

msgbox activecell.DisplayFormat.Interior.Color

 

[tyija1995]

Thank you DanteAmor!

 

[My Aswer Is This]

I had to step away for a while but I now see you have a answer.

 

[DanteAmor]

Thank you DanteAmor!

Youre welcome and thanks for the feedback