Hi,

If I change the color of a cell, I can get the color index value by using the following VBA code: "c = ActiveCell.Interior.ColorIndex".

Problem:
--------
I have a cell with conditional formatting where I change the background color based on a formula.

I tried the same code "c = ActiveCell.Interior.ColorIndex" but I always get the same value -4142 for every color!

How can I retrieve the color of this cell by using VBA?

Regards,
Elio