I'm trying to copy my conditional formatting from column to column. I have removed the absolute references but excel is still treating the formulas in the conditional format as if they still have the dollar signs around them. Can someone help me understand this?
Conditional Formatting.jpg