Conditional Formatting Code - Deletes Wrong Conditional Format

Hey,

I've been working on this code for a highlighter of the active cell. Using Conditional Formatting and the SheetSelectionChange event I have gotten this to work. The problem lies whenever there are two Conditional Formats with varying ranges.

ie: CF1 is for range A1:B10 and CF2 is for range A2

I've dont a bit of tinkering but I keep hitting walls. Here's the current code:

Please Login or Register  to view this content.

Note:I originally had it referencing the "FormatConditions.Item(1)", thinking it should be on top. Thats when I first noticed the issue and started playing with the loop. It helped me narrow it down. Add some various Conditional Formats (with various ranges) in a sheet then try this out.

Thanks for any help!

Robert Specian Jr.

Edit: Excel 2007