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