VBA Conditional formatting

S

Steven E.

I can change the conditional formats of cells with the
FormatConditions Object. But is it possible to get the conditional
formats from a cell in Excel to show them in VBA
 
B

BillCPA

You should be able to just reverse the statement. Instead of

Selection.FormatConditions(1).Interior.ColorIndex = 52

use

nn = Selection.FormatConditions(1).Interior.ColorIndex

Is this what you are trying to get?
 
Top