Comparing Conditional Formatting in VBA

[Faraz A. Qureshi]

How, can I compare the conditional format of one cell with other. For
instance, I want to create a UDF like

=SameCF(Cell1, Cell2)

so as to return a TRUE if both the cells have same conditional formatting
schemes applied, else FALSE.

Thanx in advance.

 

[Rick Rothstein]

Are you looking to see if they have the same "Conditions" (that is, what you
see in the Condition1, Condition2, Condition3 panels)? Or did you want to
know whether they had the same "Formats" (what you set after you press the
Format button for each condition), even if the triggering condition was
different? Either way, I think the function you want will probably be a much
longer than you are imagining.

 

[Faraz A. Qureshi]

I want to checkout and filter the cells not containinng the Conditional
Formatting as per the sample cell. In other words, I want to check ALL the
conditions.

--
Best Regards,

Faraz

Are you looking to see if they have the same "Conditions" (that is, what you
see in the Condition1, Condition2, Condition3 panels)? Or did you want to
know whether they had the same "Formats" (what you set after you press the
Format button for each condition), even if the triggering condition was
different? Either way, I think the function you want will probably be a much
longer than you are imagining.

 

[Rick Rothstein]

I've been looking into this on and off for a couple of days now and think
the code to do what you want will be extensive. The problem appears to be
that there is no fully defined Conditional Format object as such... that is,
you can't just test if one CF object is equal to another like you can do
with other objects... it appears you have to test each part separately....
and there are a **lot** of parts. For example, you can't just test the Font
format as an object... you have to test each possible Font property (Bold,
Italic, Size, Color, etc.) individually... and that is just one small part
of the testing... after that, there is the Borders, Line Styles, and so on.
And you have to do this for each Condition!

--
Rick (MVP - Excel)

I want to checkout and filter the cells not containinng the Conditional
Formatting as per the sample cell. In other words, I want to check ALL the
conditions.