LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing three columns, Conditional Formatting Marsh New Users to Excel 4 December 9th 09 09:58 PM
Conditional Formatting - Comparing 2 columns LinLin Excel Worksheet Functions 1 April 3rd 09 02:20 AM
Conditional formatting comparing times Mike Excel Worksheet Functions 14 February 17th 09 06:06 PM
Comparing two lists using Conditional Formatting [email protected] Excel Worksheet Functions 3 June 4th 07 01:10 PM
Conditional formatting/ comparing worksheets Excel Help! Excel Discussion (Misc queries) 0 January 10th 07 10:52 PM


All times are GMT +1. The time now is 07:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"