Hi All,
I have attached a snapshot of data.
This workbook has 1000 rows, and we need to identify duplicate prices for each row (each row is a product, the columns from G onward are supplier quotes).
How do I quickly replicate this conditional format across the entire workbook?
Thanks very much for any assistance.
1st, delete ALL the CF from ALL rows under row 2
2nd, go into the CF rul in row 2 and change the APPLIES TO, to cover the entire range you want
A word of caution - applying this to entire columns or "format across the entire workbook?" may slow your file down. Try and restrict CF to only what you need
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
Thanks for your reply.
Unfortunately if I apply the CF formula to the entire sheet, it will pickup dupe values across the entire workbook, not just for each row. Essentially I'm wondering if there's a shortcut instead of highlighting each row, clicking CF, clicking duplicate values, and then moving to the next row.
oops missed that.
Try it this way instead.
Instead of using the Duplicates rule, use the Use Formula rule, with this formula in it...
=COUNTIF($G2:$N2,G2)>1
Again, highlight the entire range you need this applied to
Thanks again.
Unfortunately once entering that formula it is now highlighting multiple values across each row, not just duplicate values. How does the formula know to highlight dupe values?
The =COUNTIF($G2:$N2,G2)>1 does a count for that row, and highlights anything that has a count higher than 1.
See the attached
Absolutely fantastic. Thank you FDibbins! works a treat.
Happy to help
If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks