Forum Discussion
Copying Conditional formatting with relative cell referencces in the formula desn't work
I have a cell H19 conditionally formatted "Format values where this formula is true" with: ="h19>$C$19" and then the colour green When I copying the cell with Format Painter to cells H20 to H90, the...
| BUDGET - C | ACTUAL - D |
| 454 | 454 |
| 258 | 258 |
| 159 | 155 |
| 357 | 357 |
| 654 | 654 |
Two Rules: formulas
=D11:D15<>C11:C15 Red
=D11:D15=C11:C15 Green
Applies to: =D11:D15<>C11:C15 same in both rules
Yes, but first one could have side effect in some situations
Yes, looks like both methods will work provided that the first row of data is selected in the current section. All good! Thanks for sharing.
What you are showing in your reply will not work. However, the format I presented works for me in my workbook which was attached. Since I am new to this, I am not sure you see it. Anyway, good luck.