I need to copy a Conditional Format where the "condition" compares two
cells on a row. When I use the Paste Format function, all references
point to the original comparative cell instead of the relative cell
by row. The spreadsheet is quite large and is updated daily. Any
hints? ~ Barbara

Presumably the CF formula has an absolute reference in it. Change that to
relative before copying and pasting.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bgpip - ExcelForums.com" wrote
in message ...
I need to copy a Conditional Format where the "condition" compares two
cells on a row. When I use the Paste Format function, all references
point to the original comparative cell instead of the relative cell
by row. The spreadsheet is quite large and is updated daily. Any
hints? ~ Barbara

The original conditional formatting formula may look like this:

=$B$2$D$2

If you want to use this formatting in a different row, remove the $
signs from in front of the row numbers.

=$B2$D2

That will change the absolute references (always refer to row 2), to
relative references (refer to the current row).

You can leave the $ signs in front of the column letters, assuming that
you want it to check specific columns.

bgpip - ExcelForums.com wrote:
I need to copy a Conditional Format where the "condition" compares two
cells on a row. When I use the Paste Format function, all references
point to the original comparative cell instead of the relative cell
by row. The spreadsheet is quite large and is updated daily. Any
hints? ~ Barbara



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html