Comparing Conditional Formatting in VBA
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 (MVP - Excel)
"Faraz A. Qureshi" wrote in
message ...
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.
--
Best Regards,
Faraz
|