Need to have conditional formatting apply to all cells in a column in EXCEL 2011

I am attaching the document I am working on. As you can see I have conditionally formatted Column C however when I try to apply it to all but the original cell that was formatted it seems to use the original cell as what it bases all other cells of of.

So Rather than applying the condition to the data in, say C4 it appears to apply it off of the data in C2, as this was the original cell formatted.

Actually the columns you mentioned have a date generated when you input a date into the preceding column. The conditional formatting actually is based on the generated date in the column. So for example if you type in a date in cell B2 it generates a date in C2, as this date approaches the coloring of text and background is supposed to change to alert the user of proximity.

I want each of the cells to change formatting as todays date approaches. I had thought that the way I had it formatted would cause cells in Column C to all base their formatting off of C2, however it looks as though it is working correctly, that is that the formatting will change off the date in the cell. So for example C15 will change based on the date that is generated in C15 and not based on the date in C2