Make sure any cell references in your condition are relative (eg.
"A1") and not absolute ("$A1$")

They should then automatically adjust when pasted.

Tim.


"bgpip - ExcelForums.com"
wrote in message ...
I need to format cells for the font to change color depending on how
the number relates to another cell on the row. I am using
Format/Conditional. When I use the Paste Format function, the
orginal comparing cell from the original row is reflected instead of
the appropriate row's cell. How do I copy the format so it reflects
each individual row's criteria? I appreciate your help! ~
Barbara[quote:bfa81e434e][/quote:bfa81e434e]