I think it is a matter of understanding...

Excel 2007 shows the formula in the first cell and also shows the range it
is applied to in a separate box...

The condition you have is correct...

Just to make sure...
Delete all conditional formattin
Select the first cell, apply the format and in the applies to box enter the
range you want it applied to...

Anything without a $ changes and anything with a $ does not change.


"Mike" wrote:

Ok, I have the exact same problem, but I can't get it to work. I actually
converted a 2003 file with allot of VBA in it, and all the conditional
formats are messed up because when it copies (special..formats only) from one
cell to multiple cells, the cell I am checking does not change with the row.
Example: I have a conditional format that goes =or(a4$a$170, a4<$a$171) with
a condition that it has a red background. This conditional format would be
initially in cell a4. Then I copy cell a4, highlight a5 through a100 and
"paste special" formats only, every cell has the exact same condition. I
need the a4 to change with the row as it is copied but it won't do it. What
am I doing wrong?????

"Damon" wrote:

So, I've added conditional formating to A2 that logically looks like this:
=if C2=0 then fill is red and if C2=1 then fill is green

I need this formating on the next 80 cells in column A and I need the check
to be on C3,4,5,6,... and so on. How do i copy the conditional formating
like that?
--
Cheers,
Damon