I don't think I explained what I am trying to do. Your formula just
indicates the first row when a part number changes. I want to have all
of the same part numbers one color and then when the number changes
then it switches color.

I tried to indicate this, if you look at the far right column it say
highlighted or not highlighted this would indicate colored or not
colored. I have sent an attachment of what it should look like.


--
mizunobill
------------------------------------------------------------------------
mizunobill's Profile: http://www.excelforum.com/member.php...o&userid=33614
View this thread: http://www.excelforum.com/showthread...hreadid=533936