Accessing which format is used in Conditional Formatting

Duncan · Feb 18th, 2002, 04:30 AM

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 · Feb 18th, 2002, 07:53 AM

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...

Feb 18th, 2002, 07:53 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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... __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 04:30 AM	#1
Duncan New Member Join Date: Feb 2002 Posts: 8	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 ]