try this --- right click on your cell and go COPY then left click and drag down as far as you need then right click PASTE SPECIAL and click on FORMATS and OK

Hi

Select all of column B or a range of cells in column B, then go to new rule on the CF in the home tab.

Rule 1: =$B1>=320
Rule 2: =$B1<320

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.