Edit Column/Row Without Triggering the "Last Modified" Cell
I`m trying to create a color code that shows the tows update status. I came up with this formula:
=IF(ABS(Modified1 - TODAY()) > 30, IF(ABS(TODAY() - Modified1) > 90, "Red", "Yellow"), "Green")
the formula works fine, but if I start working on a new row, I want the color code to be applied automatically, which can not be done without editing a new row beforehand, which would trigger the last modified cell to appear. See the Problem?
I guess what I`m trying to ask is how to apply the formula for the entire column, without the modified timestamp being triggered.
Maybe, you can think of another way to achive this too.