I'm not positive that I have a good mental picture of your worksheet
layout, but if you have numbers in a single column and you want to
change the cell background for the first occurance of several identical
values, then check out the help on Conditional Formatting.

You should be able to write a rule so that if the next cell down's
value is equal to the current cell's value AND the current cell's value
isn't equal to the next cell back up, then the background of the current
cell would be set to whatever color you want.

You may have to play a bit to make sure the formula in the rule isn't
using absolute references (ie, NOT like $A$70)


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111855