Colouring cells based on equal to or greater than value in another cell

Hi,
I am working on colouring cells if the student has met or is above their target. Im having problems with comparing cells that contain 4c, 4b, 4a etc so i am using a vlookup table and changed the target values to numbers. I would now like to colour the cells in their current result column if they are on target or above to green and not colour it if they are below. I have included a worksheet example of what i have done, i would just like someone to point me in the right direction as to how to get it to colour the cell using VBA/Macros...I'm only a beginner in using macros and vba.

Thank you for your time!

Bex

hi thank you both for your help,

I was just hoping there was an easier way as i have to do this for every year, could i use the statement in a macro so it automatically does it for spreadsheets i have to create?

Thanks again,
Bex

this is how many columns i have to do it for (attached)

Bump!......

hi bexybeeuk, please check attachment, run code "Progress_Validation"