replicate conditional formatting

[mucho]

Hello all.

perhaps this issue has been covered already. I am trying not only to replicate a cond. formatting but also auto-adapt to the new cells. see here:


Is:

=$D$12
=$D$12
=$D$12
=$D$12

should be:

=$D$12
=$D$13
=$D$14
=$D$15

thanks

[Richard Buttrey]

Hi
If I understand your request then you need to remove the absolute $ sign from the Row number ref.

Regards

[mucho]

thanks, but than I need to add it later on in order for this to be conditioned...

[brokenbiscuits]

If you remove the second $, does that work?

i.e.
=$D12

[brokenbiscuits]

Ok, ignore that, my computer playing up, didn't see the earlier response!

[mucho]

... i tried pretty much every commom method, brush, copy paste, etc.etc... but there's got to be a way

[mucho]

for those interested.....

Du musst die $-Zeichen anpassen:
- $D$12 fixiert Zeile + Spalte beim Kopieren
- $D12 fixiert nur die Spalte
- D$12 fixiert nur die Zeile