View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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