Expire date highlighted

**AaruJaan** · 08-03-2016, 08:14 AM

Hi,

I need Conditional and Formatting formula for expire date, exactly I want date highlight 10 days before expiry, please check the screenshot.

Thanks

Farhan

**Tony Valko** · 08-03-2016, 08:42 AM

Use this as the conditional formatting rule:

=AND(TODAY()>=D2-10,TODAY()<=D2)

**AaruJaan** · 08-03-2016, 09:45 AM

column A actual date and Column D is expiry data, before 10 days of actual date will be highlighted in expiry date.

**Tony Valko** · 08-03-2016, 09:49 AM

How about posting a SMALL sample file and show us what dates should be highlighted.

**AaruJaan** · 08-03-2016, 09:55 AM

please check the excel file

**AaruJaan** · 08-03-2016, 10:10 AM

can you help me?

**JohnTopley** · 08-03-2016, 11:09 AM

Have you tried Tony's formula (post #2) ?

**AaruJaan** · 08-03-2016, 11:12 AM

yes, it's not working for me

**JohnTopley** · 08-03-2016, 11:35 AM

I tried it and it worked.

Note that the Expiry Date in your sample file is wrong: it should be 10/08/2016 NOT 08/10/2016

**JohnTopley** · 08-03-2016, 11:39 AM

See attached .....

Expire date highlighted

LinkBack

Thread Tools

Rate This Thread

Display

Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Re: Expire date highlighted

Thread Information

Users Browsing this Thread

Similar Threads

I want to make a workbook expire after a certain date

[SOLVED] formula for recurring expire date

Add an expire date

[SOLVED] email when cell date expire

COUNTIF date will expire in a date range

[SOLVED] Date Function:contracts expire.

Check Expire Date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions