Highlight Duplicate Rows with Excel Conditional Formatting

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=c3stuzB-xw4

http://www.contextures.com/xlCondForm... Visit this page for the sample file and written instructions. • With Excel's conditional formatting, you can highlight cells based on specific rules. In this example, we'll highlight the duplicate rows in a table. • The first step is to use the CONCATENATE function to combine all the data into one cell in each row. • Then, a conditional formatting rule is set, to color the rows that are duplicate records. • Watch this video to see the steps.

#############################

New on site