Conditional Formatting

I've created a football league table in excel and was wondering if it was possible to use the 'arrow' conditional formatting icons to show if a team column has dropped, stayed or raised in position when I sort the teams according to points accumulated using the 'Sort & Filter' function, thanks in advance

Can you post an example of what exactly you are looking for.

It would be easier to help if I can see exactly what you are looking to do.

Thanks,
John