Value based on Font colour

Hi,

I have a list of numbers in a worksheet that are either Blue, Red or Magenta.
In the cell next to each number I need to place a 1, 2 or 3 based on the Font colour. Can I write an IF statement that will display a 1 for example if the Font in the adjacent cell is Blue? I am using Excel 2007. I am grateful for any help offered. Thank-you.

The numbers are Ladder positions of football teams over many years. The teams have played in Division 1, 2 or 3. As the years have passed I have filled in the position next to each team, and have used the 3 different colours to show the division they have played in.

you will need a macro something like this

Please Login or Register  to view this content.

If the font colour is black - it changes the value to 101
if the font colour is red - it changes value to 22