Execl 2000:

We have a workbook with a worksheet that can have a
varying number of rows. The last 5 rows however will
always have data like the following.

A B C
51 Total 70
52
53 Test1 20
54 Test2 75
55 Test3 5

We want the macro to compare the number in B53 to B51. If
B53 is greated than B51, we want A53 and B53 to be
formatted with a green fill color. If B54 is greater than
B51, we want A54 and B54 to have a yellow fill. Otherwise
we want A55 and B55 to be red.

We don't know how to get this to work because the number
of rows will always be different when we run the macro.

Appreciate any assistance.