shading based on change of values
 

I have a list of locations that repeat for a varied number of rows depending
on other data. I want to shad the first instand of the new value so its easy
to see when the location changes. How can I accomplish this?

shading based on change of values
 

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

shading based on change of values
 

Use CF with a formula of

=A1<A2


--
__________________________________
HTH

Bob

"carolm" wrote in message
...
I have a list of locations that repeat for a varied number of rows
depending
on other data. I want to shad the first instand of the new value so its
easy
to see when the location changes. How can I accomplish this?

shading based on change of values
 

Duh!

Yeah, I did over-think that one a bit! :Bgr


--
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