Conditinal Formatting with a Formula

Hello

Please see attached
I would like the colours to automatically change from the values… I know its =IF formula of sorts

Colum G = Status

Yellow - Above Target (column E), But worse than previous (column D)
Red – Actual (column F) below Target (column E)
Green – Above target


Any help would be great

Paul