I enter a date in column A, and then use a simple equation in column B to add 30 days to it. Then in column C, I will enter another date and this is where the conditional formatting comes in. If the date in Column C is less or equal to the date in Column B, I want the cell in Column C to turn green. If the date in Column C is greater than the date in Column B, I want the cell to turn red. The conditional formatting I set up works fine for row 2.

=$G$2=$B$2 green
=$G$2<$B$2 green
=$G$2>$B$2 red

Now, what I want to do is copy the formatting down the column so that it is row specific. What is happening now is that no matter what row I am in, the conditional formatting equation references row 2. I've tried copying down in a number of ways, but the formatting equation does not correct for the row. Is there any way I can make this work?