get the active color of a cell

[chibouki]

I got cells that had there color chaging automatically using a format
condition (cond#1:red if B4<10 cond#2:green if C5>100 for example...).
Now, I would like to automatically change the color to blue if the
active color is red (condition #1 true in my example).
I can get the ColorIndex of the cell:
-when no condition applied = .Font.ColorIndex
-when condition #1 applied = .FormatConditions(1).Font.ColorIndex
-when condition #2 applied = .FormatConditions(2).Font.ColorIndex
But impossible to retrieve the actual cell color... any idea?
Another way to solve my problem would be to be able to know if each
condition is true or false. But I need light on that too!!
Thx in advance,
Chib.
ps: I have a feeling this is not a easy one, but any help will be very
appreciated.

 

[Bob Phillips]

Chib,

Again not exactly sure I understand, but getting the colour is subjective.
What you may call some shade of green, I cal some shade of blue. And you
cannot rely on the colours in the colour palette, as they can be replaced.
For instance, colorindex 50 is Sea Green in the default palette, but you can
change that to red!

Tricky I think.