Zooey,

Easy answer? Pretty much, and you'll get a mess of them -- I don't know why
I'm throwing in, but here goes.

You'll have to select the column (or portion thereof), and the active
(white) cell must not be in row 1 (well, it could be, but it's confusing).
Press Enter to move it down after you've made your selection. I'll presume
A2 is active.

Format - Conditional format - Formula is: = A2<A1
Set your format, and OK your way out of the whole thing.

The formula will be copied into the conditional formatting of the other
(selected) cells. A1, if in the selection, will have something like
=A1<A65536, indicating that it wraps.

If you want the row to be highlighted (not just the cell in the column),
it's all the same, except you select the rows, not just the column of
interest.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"zooeyhallne" wrote in message
...
Hi! I am generally familiar with Excel, but need some help on this
particular problem.

I want to apply a format whe whenever the number in a column differs
from the one previous to it, a cell shading color change is applied.

For example, you have a column of numbers in Excel:

2
2
2
5 (cell shading color change applied)
5
5
5
2 (cell shading color change applied)
2
2
3 (cell shading color change applied)
etc....

It doesn't matter what color is used, just so that it is applied whenever
there is a change from the previous number.

There has got to be an easy answer to this.... thanks so much in advance
for
any help!