To highlight duplicate rows with some colour
Closed
Rashmi D S
Posts
1
Registration date
Thursday November 12, 2009
Status
Member
Last seen
November 13, 2009
-
Nov 13, 2009 at 05:33 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 14, 2009 at 05:03 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 14, 2009 at 05:03 PM
Related:
- To highlight duplicate rows with some colour
- Crimping colour code - Guide
- How to duplicate a google doc - Guide
- Folder highlight - Download - Customization
- Highlight cell if another cell contains text - Excel Forum
- How to avoid duplicate records in sql select query - Guide
1 response
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Nov 14, 2009 at 05:03 PM
Nov 14, 2009 at 05:03 PM
in excel 2007 you can do it this way.
highlight the cells/rows that you wish to work on.
select conditional formatting from the ribbon toolbar
highlight rules/duplicate values
set the colour you wish.
ok and apply.
this will highlight all that have duplicate values but the flaw is that this will give the same colour to all duplicate rows. but this will at least point out the duplicate rows for you.
hope this points you in the right direction
highlight the cells/rows that you wish to work on.
select conditional formatting from the ribbon toolbar
highlight rules/duplicate values
set the colour you wish.
ok and apply.
this will highlight all that have duplicate values but the flaw is that this will give the same colour to all duplicate rows. but this will at least point out the duplicate rows for you.
hope this points you in the right direction
