Hi guys

My first post on this forum, I had been searching for a way to sort data by background color and this forum had the perfect answer BUT I have run into an issue - when I fill down the cell formula it does not change according to the referenced cell????

Example
Eli Abt -4142
Emma Barnett -4142
Akshat Vipin -4142
Louise Pryer -4142

The cell I am referencing (Louise Pryor) has already had conditional formatting applied and the background of the cell is bright blue, but the Background colour reference is still -4142

The VBA module I am using is (as per several examples I have seen):

Function GetBackgroundColor(MyRange As Range)
GetBackgroundColor = MyRange.Interior.ColorIndex
End Function

With a call of "=GetBackgroundColor(Cell range)"

Can anyone spot my error please, I can obviously go through manually but it has become a matter of principle now to get it to work

Thanks in advance for any help that may be offered

Sean