Accessing which format is used in Conditional Formatting

[Duncan]

I have cells on which I am using a conditional format. These cells turn red if an error occurs. I would like a macro that takes me to the nest error (unfortunately the formulae are not the same in each cell).

But if I access the color property through
interior.colorindex then the color I get is the backgound color that appears if no conditional formatting is active (blue) regardless of whether the user is seeing red or blue on that cell.


Any ideas?
cheers
Duncan
This message was edited by Duncan on 2002-02-18 03:31

 

[Juan Pablo González]

You would have to look using the condition... I seem to remember J-Walk listed somewhere (Don't remember exactly where) that you could access the "state" of the conditional format, but, I may be wrong...