On Sun, 22 Feb 2004 09:56:55 -0600, in
microsoft.public.excel.programming
"Dick Kusleika" posted:

Set up CF in one cell, make sure you use relative cell references (i.e.
=A2A3, not =$A$2$A$3). Select the cell and Edit - Copy. Select all the
other cells that you want to have the same CF and choose Edit -
PasteSpecial - Formats. Your references, being relative, will update
properly.

Thanks Dick (and Tom!). I was using Absolute references (which was
what conditional formatting was doing). It's all fine now I changed
the values to Relative references.

Thanks feller!

--
Phil
To reply delete "NOTHANKS."