For a field I have conditional formatting with custom formula:
=today()>C8+30 with different styling, basically I want to have a visual styling to highlight older and oldest stuff, two weeks and month. This works. Column
C have a date, row can be any row
N does not help.
However the problem is that I have new rows all the time and it would be easier just to copy-paste the field with rules, and change the date. Rules, however stay as referring to the original here
Could I replace the specific
N with a
self() or is there something like that - to make it more generic copy/pasteable conditional formatting?