T
Takeadoe
Gang,
I spent the last hour searching through some 600 posts on conditional
formatting. I found some elaborate solutions, but I'm thinking maybe
I'm asking too much with the following:
A sample row looks like the following:
1 1 2 2 3 4 4 5 5 3 3 3 4 4
I would like to change the fill color of the cell when the value of the
cell changes. In most cases there are no more than 3 or 4 different
values out of 25 in the row and in most cases they either descend or
ascend throuhout. Problem is I have 88 rows and the values vary
considerably across rows. So, I guess what I'm after is - if the cell
to the left is different, change colors, otherwise, don't. As always,
help is genuinely appreciated.
Am I asking way too much?
Mike
I spent the last hour searching through some 600 posts on conditional
formatting. I found some elaborate solutions, but I'm thinking maybe
I'm asking too much with the following:
A sample row looks like the following:
1 1 2 2 3 4 4 5 5 3 3 3 4 4
I would like to change the fill color of the cell when the value of the
cell changes. In most cases there are no more than 3 or 4 different
values out of 25 in the row and in most cases they either descend or
ascend throuhout. Problem is I have 88 rows and the values vary
considerably across rows. So, I guess what I'm after is - if the cell
to the left is different, change colors, otherwise, don't. As always,
help is genuinely appreciated.
Am I asking way too much?
Mike