Conditional Formatting

Help! :) I cannto get my conditional formatting to work on my sheet - what am i doing wrong. Here is an example of the format i have used

We are trying to use data from anothet column to turn a seperate column green or red - is this possible? Or can i use a formula to do this?