Forum Discussion
Copying Conditional formatting with relative cell referencces in the formula desn't work
That is correct behavior, you may check on the sample. Let for such sample
we apply CF rule as in your post only the the cell D15 and as the next step apply by Format Painter to all other cells in our ranges. Rule formula will be
It is still D15 in rule formula but that's what we need. Engine scans Applies to ranges one by one cell and apply rule formula same way as if you drag D15 cell here. Other words , for F15 formula works as =F15>Budget!F15; for F16 as =F16>Budget!F16, etc.
If we change initial formula on =D15>Budget!$D$15*1.05 we always will be compare with Budget!$D$15, e.g. on next range F15 will be cvompared as =F15>Budget!$D$15.
Of course, if do not "paint" by Format Painter but double click on it and navigate with that through range cells, we will generate a lot of new rules with "correct"cell references
I've come back to this mid-year to update the spreadsheet some for my wife.
I am new to conditional formatting but have tried to follow the example - even typing your example letter by letter in the CF Rule Manager.
It' not working for me.
Rule
Formula ="d13>BUDGET!D13"
Format
RED text, red Fill
Applies to:
Summary!$D$13:$D$52,Summary!$E$13:$E$52,Summary!$F$13:$F$52,Summary!$G$13:$G$52,Summary!$H$13:$H$52,Summary!$I$13:$I$52,Summary!$J$13:$J$52,Summary!$K$13:$K$52,Summary!$L$13:$L$52,Summary!$M$13:$M$52,Summary!$N$13:$N$52,Summary!$O$13:$O$52
Nothing happens on the Summary Sheet cells that I am trying to CF.
Perhaps you see something obvious [to you] that might assist me.
Perhaps you may submit sample file removing all extra and sensitive information
I'll try that. I am completely unaware the " " is required. Nor do I understand their operation.
But, I'll try it. Thanks again.