conditional formatting expiry dates


M

mooty

Hi All,

I am trying to conditional format a spreadsheet that i have licence expiry
dates but want to flag these 30 days prior to expiry but also want the actual
expiry date to also highlight if it has gone over the 30 days, i seem to be
able to get the dates correct but they are staying highlighted, any
suggestions??

Eg B2 is 30 earlier than C2, really just unsure of the formula to use.

Thanks in advance.
 
Ad

Advertisements

F

Fred Smith

"30 earlier than C2" is:
=c2-30

It's unclear what you mean by "30 days prior to expiry". I expect you mean
once it's within the period 30 days before expiration. If so, try:
=b2>c2-30

Regards,
Fred.
 

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