Results 1 to 3 of 3

If then Statements Using Dates

This is a discussion on If then Statements Using Dates within the Excel Questions forums, part of the Question Forums category; I would like to create an "If then" statement to highlight an excel box with a date in it if ...

  1. #1
    New Member
    Join Date
    Feb 2003
    Posts
    18

    Default If then Statements Using Dates

    I would like to create an "If then" statement to highlight an excel box with a date in it if todays date equals or is greater than the date in the excel box.

    Any help on how to write the if then statement, or an easier way to go it??


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    66,276

    Default Re: If then Statements Using Dates

    It looks like you can use Format|Conditional Formatting. Read the Help file, and search thru the threads here, on conditional formatting.

  3. #3
    New Member
    Join Date
    Nov 2003
    Posts
    26

    Default Re: If then Statements Using Dates

    Select Conditional Formating... from Format menu

    Conditional Format form appears, fill in as below:

    Condition 1
    Cell value is : less than or equal to : =Today()

    Then select the Format... button and
    set the cell format to what you like

    Click OK

    Should do the trick

    Budgieboy

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com