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.

Hi Atomic,

Try using this formula:

=IF(TODAY()>D4,"Expired","In Date")

and then apply conditional formatting to the cell containing the
formula to change the colour when it reads 'Expired'

HTH

Regards

Michael.

set a conditional format where th ecell value >(Today()+60) and set is to
turn the cell background red. no need for complex formulae

"(E-Mail Removed)" 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.
>