highlight the rows that have identical data in all three columns

**MaartenRo** · 01-12-2023, 10:38 AM

Hi,

I have a spreadsheet with many rows and three columns of data. I want to highlight the rows that have identical data in all three columns. How do i do this?

**Pepe Le Mokko** · 01-12-2023, 10:52 AM

Select your range (A1:E3, say)
Apply following conditional formatting :

Formula:

Please Login or Register  to view this content.

and format as required
( change the ; to , depending on your regional settings

**MaartenRo** · 01-13-2023, 09:27 AM

thanks for the help!

highlight the rows that have identical data in all three columns

LinkBack

Thread Tools

Rate This Thread

Display

highlight the rows that have identical data in all three columns

Re: highlight the rows that have identical data in all three columns

Re: highlight the rows that have identical data in all three columns

Thread Information

Users Browsing this Thread

Similar Threads

Combine like rows based on if 2 or 3 columns are identical and adding columns that arent

[SOLVED] Match identical value in one column with changeable rows and columns

Highlight two identical rows - user warning

Help with grouping identical rows/columns

To highlight Header Rows/Columns or Banded Rows/Columns in Excel 2007

Deleting duplicate rows when ALL columns are identical?

Bookmarks

Bookmarks

Posting Permissions