Check if conditional formatting is applied or not.

Question

Using Excel VBA code is there a way I can check if a particular cell has performed conditional formatting or not?

I have data in one column with 80,000 cells.

I used the following code, but it gives the same value for Interior.ColorIndex or Interior.PatternIndex or Font.Bold regardless of whether code formatting is applied or not

Sub Check_CF() MsgBox Range("B4").Interior.PatternColorIndex End Sub 

My conditional formatting rule doesn't matter. I can change the rule if I can check if it applies or not.

Please, help. Thanks at Advance.

Answer 1

Found this rather long article with examples of related functions that might help you: http://www.xldynamic.com/source/xld.CFConditions.html