This could be done by a VBA function but I'm curious how this will be checked. You have the data, is it being continuously changed? Do we need to check it continually? Do we need to compare all values of familyX and familyY or just two specific rows at a time? Are familyX and familyY constantly being compared or do we need to compare familyX and familyZ as well?
-----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mehdi_21 Sent: Friday, February 27, 2009 7:51 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ problem highlighting duplicated cells based on a condition ---------------------------------------------------------------------------- ---- hey guys i'm using a table like this one : A B C D 1 familyX | value1 | value2 | value3 2 familyY | value1 | value2 | value3 3 familyY | value1 | value2 | value3 . . n familyX | value1 | value2 | value3 if value1 from familyX equals value1 from familyY then highlight the two rows. need help plz regards --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
