Hi All.....
I would like to alternate the row color from gray to none, for each group of
rows according to the value in the cells in column G. That is, starting with
row 11, I want no background color, then if G12=G11, likewise row 12 would
have no color, but if G12<G11, then the background color of row 12 would
switch to gray. Likewise progressing down column G, as the values change
from the one above it, so does the row color, if the values are the same as
the one above, the row color would stay the same as the one above. The
entire column is sorted in order so there would be no like values showing up
out of order. The length of column G will be unknown.

Example
row Col G Color
11 aa none
12 aa none
13 bb gray
14 cc none
15 cc none
16 cc none
17 dd gray
18 dd gray
19 ee none

TIA
Vaya con Dios,
Chuck, CABGx3