Hi-
I am trying to format a file, which has a list of data that is grouped based on an ID code.
Ex.
001 James
001 Jenny
002 Jimmy
002 Connor
003 Steven
003 Sean
003 Jan
004 Danny
004 Grant
The duplicates would be identified based on their ID# number (ex. 001) and every other set of duplicates needs to be highlighted. Ex. so the 001 & 003 data sets would be highlighted but not the 002 data set.
I am not too familiar with VBA coding, is there a function or set of functions that would allow me to format the data based on the criteria described above?
You can use the built-in Conditional Formatting using the formula option and this formula:
=ISODD(TEXT(A2,"#"))
Assumes row-1 is a header row.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
This function doesn't work as I need it to highlight every other set of duplicates. Is there another formula / function that will allow me to highlight the rows of every other sets of duplicates?
Works fine for me. Perhaps you should post a sample workbook (fake data).
See attached.
Highlight Every Other Group.xlsx
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks