LinkBack URL
About LinkBacks
hi,
i want to highlight row if duplicates find with three column
thanx
hi,
i want to highlight row if duplicates find with three column
thanx
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 *
A little more information required.
Attach a sample workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Are you familiar with Conditional Formatting?
Perhaps a rule based something like...
=COUNTIF(A1:C1,C1)=3
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Workbook attached
Try
=IF(COUNTIFS(C:C,C6,D:D,D6,E:E,E6)>1,"Duplicate","")
Thanx alot JohnTopley
its giving me a closer result
i used conditional formatting and given below code provided by you
actually its formatting the only column c
Please Login or Register to view this content.
while i want to highlight column c:e
thanx for your help
Apply rule to each column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks