I am trying to create a chart that when I input my gains for the day, it will compare it to the projected gains, stay red if lower, turn green if equal or higher.

I have attached 2 pictures showing what is happening.[(https://i.stack.imgur.com/5s1BE.png) (https://i.stack.imgur.com/wCuJ5.png)]

I programmed the first cell and it works fine. When I attempted to copy/paste the formatting down the column, and expected it to behave like all other formatting/formulas and adjust the relative cells down the column. Instead, it only hard-references cell C7.

I also double-checked the conditional formatting wizard for each cell. It confirms the problem. However the range is in properly.

To recap, the formatting is behaving as though I wrote the reference cell as $C$7 (a hard references) instead of using each cell’s relative reference (the cell two columns before it).