tough condtional formatting question

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
 
B

Biff

Based on your sample which will fill the range A1:N1.....

Select the range B1:N1
Goto Format>Conditional Formatting
Formula Is: =B1<>A1
Click the Format button
Select the desired style(s)
OK out

Biff
 
T

Takeadoe

Biff - Obviously I've got a long way to go... Thank you for the help.
It worked like a charm.
 
B

Biff

I've got a long way to go...

Well, look at it this way.......

Each day you get closer and closer!

Thanks for the feedback!

Biff
 
T

Takeadoe

Sorta like death, I guess. Some are not as forgiving as yourself of
dumb questions. Appreciate the patience and the help.
 
Top