Difficult Excel Conditional Formatting Question

[wkilgroe]

I have an Excel Add-in in which I need to be able to tell if a cell background color has been modified due to conditional formatting. I thought that I could check the value of "Application.Worksheets(sheet).Cells(Row, column).Interior.ColorIndex" but the value for this always stays at the value for "No Color" rather than changing when conditional formatting has altered the color. Interestingly, if I manually change the background color, checking "Application.Worksheets(sheet).Cells(Row, column).Interior.ColorIndex" will work correctly. Is this just a flaw of Excel? Any ideas?

Thanks in advance

 

[SkipVought]

See posting thread707-742619

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com