Hi

Thanks for the replies.

Unless I am reading these wrong this still doesnt work

In my example

B2 = 320 C2 = 75
B3 = 80 C3 = 75
B4 = 36 C4 = 75

I need the numbers in column C to be green or red depending if they are higher or lower than the number to the left. becuase the number to the left is always different (320, 80, 36) I need the CF to change to

=$B1>=320
=$B1<320
=$B2>=80
=B2<=80
=B3>=36
=B3<=36

but i dont want to have to write this CF every time

when I select B2 through to B4 I get an error that says

you cannot use a direct reference to a worksheet range in a conditional formatting formula.