Hi,

I've setup excel to take the alphabetical records I have (1 row = 1 record)
and perform a calculation on each row that eventually makes the spreadsheet
appear with a green or white background for each differnt name. Column A
contains the last name of the person in each record. So...

A B C Z
1 LAST FIRST INVOICE ........
2 Kirkpatrick Lady 72772 1
3 Jones Mister 72554 2
4 Jones Mister 72555 2
5 Smith Guy 73301 3

In some column off-screen like column Z in each row starting with row 2
where the first record is, I tell Excel to determine if the last name above
the current row is the same as the last name in the current row. If the
names are different then add 1 to the number above itself (in column Z). If
the names are the same then carry the number above itself. (we dont have so
many clients that i need to worry about the first name check yet)

The formula for cell Z2 is : =IF(A2<A1,Z1+1,Z1)
The formula for cell Z3 is : =IF(A3<A2,Z2+1,Z2)
etc...

This works very well with conditional formatting for the rows, making the
odd numbers in the cell produce a green pattern background and the even
numbers staying with a white background.

My problem is when autoformat is turned on and some of the rows disappear.
The calculation STILL calculates the hidden rows and messes up the
green/white/green/white altering pattern. Any way to make the calculation
perform on only the visible rows?