Hi

I am having an issue with conditional formatting and i was hoping someone could help, I've tried a few searches and tried a few things but it does work

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

I CAN create a conditional format that says if B2 is equal to or greater than the number in that cell then the format the text green, and if it is less than 320 to turn it red.

But the problem is when I use the handle on the bottom right to drag down the "rule" still references cell B2 and C2.

Now if i did a formula like =B2+C2 and i dragged it down the next formula would change to =B3+C3 and then =B4+C4 and so on, I want the conditional format to do the same as the numbers in column B are all different.

Hope ive explained that clearly.

thanks in advance