Excel conditional formatting

Closed

Rajasekar - Jun 10, 2010 at 07:19 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 10, 2010 at 11:17 AM

Hi,

I have the table having 8 Coloumns and abt 800 rows.

I want to highlight the duplicate rows based on 4 columns.

I gone through remove duplicates, but it is removing the data, but i need the same function only to higlight the duplicate valuse.

Thanks in advance,

Rajasekaran

Excel conditional formatting
Excel date format dd.mm.yyyy - Guide
How to clear formatting in excel - Guide
Excel free download - Download - Spreadsheets
Number to words in excel - Guide
Excel marksheet - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 10, 2010 at 11:17 AM

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

How to calculate positions (1st,2nd,3rd...) in Excel

Conditional format based on another cell containing text

Similar discussions

Subscribe To Our Newsletter!