+ Reply to Thread
Results 1 to 3 of 3

Conditional format and expiary date

  1. 05-15-2014, 08:07 AM #1
    nooredein is offline
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    MICROSOFT OFFICE 2019
    Posts
    193

    Conditional format and expiary date

    Hi everybody

    Attached file of medicines with expiary dates
    If expiary date is 1 month or less far from today then give me alert...!

    thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-15-2014, 12:17 PM #2
    nooredein is offline
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    MICROSOFT OFFICE 2019
    Posts
    193

    Re: Conditional format and expiary date

    Hi

    no reply yet?
    Reply With QuoteRegister To Reply
  3. 05-15-2014, 12:33 PM #3
    ben_hensel is offline
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Conditional format and expiary date

    Format by formula:

    =D4 < TODAY() + 30
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Format for blanks & today date less than 42 days from another cell date
    By Tom Henderson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2014, 10:13 AM
  2. Conditional formatting based on date - delete format if a date is entered in next cell
    By menstonbantam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  3. [SOLVED] Conditional Date format
    By tangomj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2013, 04:08 PM
  4. How to conditional format cells based on whether today's date is past a due date criteria?
    By Emvills in forum Excel General
    Replies: 1
    Last Post: 09-30-2012, 03:01 PM
  5. Conditional Format - One Date falling after Another Date
    By Rosens in forum Excel General
    Replies: 4
    Last Post: 04-19-2011, 09:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1