LinkBack URL
About LinkBacks
hello,
I have data in column c3:c1000, column d3:d1000, column e3:e1000 and column f3:f1000
i want to use conditional formatting of Duplicates,
e.g
if at a time find duplicate record in all 4 column than apply conditional formatting
hello,
I have data in column c3:c1000, column d3:d1000, column e3:e1000 and column f3:f1000
i want to use conditional formatting of Duplicates,
e.g
if at a time find duplicate record in all 4 column than apply conditional formatting
create a helping column where you concatenate the values from columns C,D,E,F. then apply the conditional formatting for duplicates to the helping column
Click on the star if you think I helped you
Hello, adyteo
ur idea is perfect, but i got the solution, for who have this issue, i m posting here the solution
Please Login or Register to view this content.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks