how can i highlight cells with color, which contain duplicates form a separate excel sheet
I have one query regarding the Microsoft excel. I have one excel file with multiple sheets.
What i want to do is -
- Highlight any values (in colour) on the current sheet that I'm in
- which contains a duplicate from the previous sheet
Help would be appreciated!!
Re: how can i highlight cells with color, which contain duplicates form a separate excel sheet
Which version of Excel are you using, if it is excel 2007 then follow the below procedure:
- First you need to highlight the cells/rows that you wish to work on.
- Then select conditional formatting from the ribbon toolbar
- After that highlight rules/duplicate values
- Then Set the colour you wish.
- Just click Ok and apply.
You can also refer to similar topic here: http://forums.techarena.in/windows-software/1290574.htm
Re: how can i highlight cells with color, which contain duplicates form a separate excel sheet
You really cannot sort a column on the basis of a conditional format. If you want to sort the data so that the duplicates are in one area, follow these steps:
First, type the heading Duplicate in cell B1. Then, type this formula in B2:
=COUNTIF(A:A,A2)>1
With the cursor in cell B2, double-click the AutoFill handle (the little square in the lower-right corner of the cell) to copy the formula all the way down the column.
You can now sort the columns by column B (descending), then by column A (ascending), to show the duplicate invoice numbers at the top of the range.