Jump to content

Excel Formula Query


Offshore
 Share

Recommended Posts

Need some excel assistance.

 

I've got a spreadsheet which has a column of numerous dates (expiry dates for medicals) and what i'd like is for the date or cell to be highlighted 'red' when the expiry date becomes 90 days and less from present.

 

Any ideas or help would be mucho appreciated.

 

 

Link to post
Share on other sites

Sorry Dave, can't get that to work at all,

 

is =AND(XX-TODAY() < 90,XX-TODAY() >0) all one string to type in? (XX being the cell ie D6)

Tried putting that in exactly and variations of still with no joy.

 

The excel version is 2007 (if that makes a difference).

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...