Hello all ,

I have greatfully received these two macros in this sheet that gets data from each date
but one row above .

The data comes from cols AL and AO .

Hopefully I am wanting to add four different colours to the macro named FIFTYBACKWORKS
or the other one .

The 4 x colours represented come from col AB .

Good - brown
Dead - green
Slow - Light blue
Heavy - blue

I have approx 450,000 rows and the two current macros do this on my computer in about
13 minutes , which is fine .

Also hoping that if this is possible it wont turn in a very long time to churn through . So looking for
maximum speed if possible if at all .

Many thanks so far .