Remove the $

from
"=$M$3"

to

"=$M3"

the dollar sign is fixing the row at 3 and not allowing the fomula to change
as you copy the formula down the row.

"joel" wrote:

Post your code or formula. It should be a simple fix.

"mattagc" wrote:

Hello,

I've been having "issues" with Excel 2007 and conditional formatting.

I've been trying to get an icon set (arrows) working with my data for awhile
now, and after several hours of searching the net, I'm still at a loss.

I have 180 groups of data that this needs to be applied too, so I don't want
to have to do it one cell at a time.

Here's what I'm trying to do:

When the cell L1 is greater than M1, display a red arrow, if they're the
same, yellow arrow, and if it's lower, green arrow. I have this working. The
issue comes into play when I try and copy it through cells L2 through
L181...it all references back to cell M1 because of the required absolutes.

Is there an easy workaround to this, or am I stuck creating a rule for all
180 cells?

Thanks in advance,

Matt