Adding an alarm
set a conditional format where th ecell value (Today()+60) and set is to
turn the cell background red. no need for complex formulae
" wrote:
Hello I need some help.
I have a sheet and in the cell C4, the start date of a temporary
vendor is entered. Cell D4 has a formula to work out the date which
the vendor expires (+ 60 days)
I want a formula to let me know when cell D4 is out of date ie on or
after todays date.
Ideally I would like for the cell to turn a different colour.
Can any of you brain boxes help me?
Thanks.
|