"GS" wrote in message ...


As Gord suggests, you MUST use formulas AND the ref to column A MUST be
absolute. If you did not prefix A with the $ character then your other
columns are referencing themselves and not column A. Clicking on any
cell in B:J and opening the CF dialog should reveal what's wrong.

--
Garry

=========================

Hi Garry

Thanks again.

Yes that's what I was missing and I can see the difference it makes now.

Cheers

Ian I^)