Excel – Make cell color the same as another cell color and keep formula

colorsconditional formattingexcelexcel-formulavba

In Excel 2007, I've conditional formatting for column Q:

  • values > -5 = green
  • values between -5 and -25 are yellow and
  • values less than -25 are red.

I want cell P5 to have the same color as Q5, Cell P6 to have the same color as Q6 and so forth.

The value in cell P5 is dependent on a formula (K5-C5),
the value in cell P6 is dependent on a formula (K6-C6) and so forth.

How can I change the color of the cells in column P so they are equal to their "matching" cells in column Q, without ruining the formulas created in column P?

Best Answer

If I have understood you correctly, then you don't need VBA for this. Simply highlight the relevant range and not just column Q while conditional formatting. See this example

enter image description here

Related Topic