Conditional Formatting Not Moving When Sorting

Hey Everyone,

I've been developing a database for my band, so we can keep track of our songs quality level and what we should practice, and so we can quickly look when we need to set songs for gigs (this hasn't had data entered our songs are not all on the lowest quality :D )


I've struggled through the coding of this database and i am finally stumped and just over it.


On the main Database page, i want to be able to sort via alphabetical, colour, ect. On each song has conditional formating, which changes colour depending on the level the song is at.

What should happen is when i sort it, the song name moves and so does the condtional formating accordingly

What is happening is the song name moves but the conditional formating stays where it is. Which means the colours are updating for the wrong song

I have attached the file to this.

Any help would be appreicated


Thanks

Bensley