Excel spreadsheet change colour of cell back ground depending on d
 

Hi Guys

I have an excel spreadsheet that i use for insurance details.

I would like to have a formula set up so i know 2months / 60days away from
when an insurance expires.

I would like another colour for when the insurance has expired and new
details are over due.

Thanks

look forward to your response

Natalie

Excel spreadsheet change colour of cell back ground depending on d
 

See http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nataliec" wrote in message
...
Hi Guys

I have an excel spreadsheet that i use for insurance details.

I would like to have a formula set up so i know 2months / 60days away from
when an insurance expires.

I would like another colour for when the insurance has expired and new
details are over due.

Thanks

look forward to your response

Natalie