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.