onOpen. check dates in column, colour background
Posted on 2016-11-24
i'd like an onOpen and onEdit which checks down column A on one particular sheet which is called dataEntry. Cells which contain a date that is 6+ days old should have their background colour changed to red.
please note i have several other onOpen/onEdit functions so i'm aware they needs unique names and triggers setting up.
i've found a few examples on line but none of them are quite what i'm looking for and unfortunately my very basic knowledge means i'm struggling to edit them.