# Copy a conditional format for a row across an entire sheet

1. ## Copy a conditional format for a row across an entire sheet

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.

2. ## Re: Copy a conditional format for a row across an entire sheet

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

3. ## Re: Copy a conditional format for a row across an entire sheet

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.

4. ## Re: Copy a conditional format for a row across an entire sheet

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

5. ## Re: Copy a conditional format for a row across an entire sheet

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?

6. ## Re: Copy a conditional format for a row across an entire sheet

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

7. ## Re: Copy a conditional format for a row across an entire sheet

Absolutely fantastic. Thank you FDibbins! works a treat.

8. ## Re: Copy a conditional format for a row across an entire sheet

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)

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1