Two columns titled "Unit1" and "Unit2" in the header row (row 1).
These columns CANNOT be referenced by letters as they randomly change which column they are in, they must be found via text match.
Need to compare, row by row, the values in both columns.
If on any row, the value in the "Unit1" column = "Unit2" column, then highlight that entire row yellow.
Dim numberofduplicaterows as integer
set numberofduplicaterows = (the number of duplicate rows)
if no duplicate rows found then do nothing.
Here is a solution that uses conditional formatting instead of VBA, if that would be acceptable. You can move the headers around to see how the highlighting follows the Unit1 and Unit2 columns.
It wasn't clear which row you wanted highlighted. This macro will highlight the row under "Unit1" where if matches "Unit2".
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Maybe:
Please Login or Register to view this content.
Originally Posted by Mumps1
It wasn't clear which row you wanted highlighted. This macro will highlight the row under "Unit1" where if matches "Unit2".
Please Login or Register to view this content.
Thank you. Is it possible to modify this to do the same, but only look for duplicates in the "Unit1" column?
I.e. if two rows in the unit1 column have the same value, highlight them both, and then at the end dim the number of duplicate rows as integer?
Hi Ks,
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks