On 22 Dec 2004 13:12:55 -0800, "Bill_S" wrote:

Another way to do the same thing would be to change the absolute
reference. Instead of $A$1=1, use $A1=1 in the formula. Then you can
copy and Paste SpecialFormats and excel will adjust the condition
formula for each row.

Hi Bill,

Many thanks - remomving the second absolute reference did it - it
works just as I hoped now.


--
Cheers

Peter

Remove the INVALID to reply