Copying Conditional Formatting with Formulas Accross Rows [Solved]

Ask a question Wearrien 1Posts Wednesday February 1, 2017Registration date February 1, 2017 Last seen - Last answered on Feb 2, 2017 at 11:14 AM by Wearrien

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.

Any Suggestions

plus moins
Hi Donna,

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.

Best regards,
Wearrien- Feb 2, 2017 at 11:14 AM
Thanks, that worked
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!