Hi guys, not posted a new thread on here in a while as my excel knowledge develops. However, I'm stumped with a relatively simple idea.

Does anyone know how I can display a range of numbers as a percentage.
i.e...

Column A Column B
1 200 100%
2 150 75%
3 100 50%
4 50 25%
5 0 0%

Column A will be a monetary value in millions - Formatted to an accountancy field.

B1 will 100% because A1 is the highest number in the range of A1:A5



Any help greatly appreciated.

Jason