Takes some getting used to in Excel 2007 David.

If you look at the rule for each cell the A2 does not show as incremented
BUT in actual fact, Excel has incremented internally somewhere so the CF
does work as planned.


Gord

On Tue, 17 Nov 2009 21:17:35 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Make sure that you have A2 and A3, not A$2 and A$3, in your conditions.

I am told that Excel 2007 shows confusing information in CF, so you're
better using 2003.