I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Example: =IF($C7<$M7,$C7>$N7) suppose to be yellow, but when copied to another cell in the row that meets this criteria it doesn't change the color. It works in the initial cell properly.
Copy conditional formatting with formulas
Copy conditional formatting - Best answers
Apply conditional formatting to entire column - Best answers
That is because you put a dollar symbol in front of the column letter. It will make the column reference absolute, meaning that when you put =$C7 in a cell and drag it to the left/right, it will remain =$C7.