I have a conditional format in C2. I have a bunch of columns that I want this
same format to apply to, but whenever I do the condional format formula never
changes. It will change If I copy down the same column, but not if I copy to
different columns.

For instance, C2 will change color depending if it will match with C1. I
want D2 to do the same with D1.

When I use the format painter the format does not work in column D and Cell
C1 will now color all cells in the row rather than the one cell, itself.

Am I doing something wrong?