Copying conditional formatting

[romajr86]

Hi, I set up conditional formatting for a cell C6 based on cell B6, and want to continue it down the row (C7 based on B7, C8 based on B8 etc..) but when i either use the format copy tool OR copy the cell down the rest of the C column, it all works off the original B6 cell and doesnt adjust..

Is there a way to copy the conditional formatting based on cells and have it automatically figure out to move on down the columns?

I attached a pic of the spreadsheet i have up. What im trying to do is compare projections of performance to actual performance (in this case my fantasy football players).

I have the player name, how many points they are projected to score, and then what they actually did. You can see the first player in B6 was projected 16 and actually got 18 in C6. I made it so if the actual is greater than the projected it is in blue, and if less than the projected it turns red.

If I copy this format down the line for the other players (c7,c8,c9 etc), it all still works off of the first players projection B6. I know if you have a regular formula (b6+c6) and copy that down a column it adjusts to the whole column (b7+c7, b8+c8, b9+c9 etc) but with this conditional formatting, it doesnt do that.

I know obviously I can do it for every "C" cell individually, but who the heck wants to do all that?? I have 14 more weeks of this to fill out!

Help?