I have a routine that looks for shaded cells with
For Each c In ActiveSheet.UsedRange
If c.Interior.Color <> ActiveWorkbook.Styles.Application.Cells.Interior.Color Then
However this apparently doesn't catch conditionally formatted cells. c.Color doesn't get it. Since there's no @#$%ing c.BackgroundColor or c.PatternColor, what can I reference that has the conditional formatting?
Well, what do you know, I just found it - sort of - while typing this: c.FormatConditions.Interior.Color. HOWEVER ... it seems to always be the conditional color - i.e., this alone is not triggered by the "conditional condition."
So, my question is, is there a variable that contains the displayed color?
Better still, is there a variable that tells if the conditional formatting has been tripped?
For Each c In ActiveSheet.UsedRange
If c.Interior.Color <> ActiveWorkbook.Styles.Application.Cells.Interior.Color Then
However this apparently doesn't catch conditionally formatted cells. c.Color doesn't get it. Since there's no @#$%ing c.BackgroundColor or c.PatternColor, what can I reference that has the conditional formatting?
Well, what do you know, I just found it - sort of - while typing this: c.FormatConditions.Interior.Color. HOWEVER ... it seems to always be the conditional color - i.e., this alone is not triggered by the "conditional condition."
So, my question is, is there a variable that contains the displayed color?
Better still, is there a variable that tells if the conditional formatting has been tripped?
