You should probably start a new thread, rather than piggybacking on another
one. Nevertheless...

Using the sample data & layout you provided, try the following:

1. Select cells B2:B17 (or whatever the last row of data is)
2. Select Conditional Formatting from the Format menu
3. Change 'Cell Value Is' to 'Formula Is'
4. In the textbox, enter =(B2=B1)
5. Click the Format button and select the formatting options you want to
appear if the condition is TRUE (red bold text, etc.)
6. Click OK

Hope this helps,

Hutch

"lostinformulas" wrote:


I have a similar type question, I have thousand of lines of information
an need to have duplicate infromation highlighted or font color change
for easy viewing. I sort the worksheet by the part number column "B"
Example:
Row Column "B"
1 H0000983400008
2 H0000983400009
3 H0000983400010
4 H0000983400010
5 H0000983400010
6 H0000983400011
7 H0000983400012
8 H0000983400013
9 H0000983400014
10 H0000983400015
11 H0000983400016
12 H0000983400017
13 H0000983400018
14 H0000983400019
15 H0000983400020
16 H0000983400021
17 H0000983400022

I would like the cell to highlight or change the color of font on cells
4B & 5B, because this part number has appeared in the row above.


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=560383