see attached workbook
Hi

Need a macro that will edit the backgorund colour in row 21:26 column b irrespective where the data lies in column B if records increase or decrease over time.

So backgound colour transparnet NO FILL.