+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    03-15-2010
    Location
    victoria, canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    conditional formatting expiration dates

    Hi, I'm new to this, so bare with me.
    I have a bunch of laptops that regularily get signed out, anywhere between 1-14days.
    I have a start date (B2) and return date (C2)... for example, Sign out is March 13, Return date is March 25

    All I want is to have the sign out date go red when its due on that day.
    So far I cannot find any google examples that meet my specific needs.
    I'm trying conditional formatting in excel 2007 but I cannot figure out the string.

    Thanks for help
    Shane

  2. #2
    Forum Guru darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Colorado, US
    MS-Off Ver
    2007
    Posts
    2,140

    Re: conditional formatting expiration dates

    =IF(C2>=Today()) in the conditional formatting rule, then formatted how you want.

  3. #3
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,441

    Re: conditional formatting expiration dates

    Here is a useful link for help on understanding Conditional Formatting.

    Excel Conditional Formatting -- Introduction
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.2.0