Cell colour change.

S

Spaceace

Please help.
I have 3 cells next to each other on a spread sheet. First cell has an order
date the second cell has a delivery date. I want the third cell to display a
differant colour when the todays date gets within a set amount of days of the
delivery date. Like a status cell. E.g Goes green within a week of the
date/goes red within 2 days of the delivery date.
please please help me.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top