+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting to highlight rows that repeat

  1. #1
    Registered User
    Join Date
    09-17-2015
    Location
    Los Angeles, USA
    MS-Off Ver
    2013
    Posts
    5

    Conditional formatting to highlight rows that repeat

    Is there a way to use conditional formatting to highlight a range of cells that repeat the same exact values throughout an entire work sheet?

    Example:
    12121 - Highlight
    23232
    12123
    34343
    12121 - Highlight
    13232
    56565
    12121 - Highlight

    This is just a quick example of what I wish to accomplish. The values must be exactly the same in each column and as an FYI some cells may be blank.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Conditional formatting to highlight rows that repeat

    bayala87, Good afternoon.

    Suppose your data is at A1:A100.

    Use this formula at Rule 1 of Conditional Format:

    =COUNTIF($A$1:$A$100;A1)>1

    Is that what you're looking for?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marcílio Lobão

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] My Conditional Formatting does not highlight rows, only cells in a column
    By chrisneu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2014, 07:52 PM
  2. Replies: 5
    Last Post: 11-08-2013, 05:57 AM
  3. [SOLVED] Conditional Formatting - Highlight All Rows in Table with Error in Any Cell
    By jgray in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-18-2013, 05:04 PM
  4. Conditional Formatting - Highlight All Rows in Table with Errors in Cells
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2013, 03:34 PM
  5. [SOLVED] Conditional Formatting to Highlight Entire Rows
    By christopherw34 in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 04:12 PM
  6. highlight rows / columns using VBA & Conditional Formatting problem
    By MARKSTRO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2010, 12:00 PM
  7. Conditional Formatting - Highlight Rows if a cell contains text
    By crepe in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-13-2007, 08:25 PM

Bookmarks

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