+ Reply to Thread
Results 1 to 2 of 2

Conditional fomatting with date and time in excel

  1. #1
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    Conditional fomatting with date and time in excel

    Hi all,

    I have a problem on conditional formatting with date and time.

    I hava a cell A1 that has date and time and I want to conditionally format its adjecent cell if the value of cell A1 is greater than 3 days compared to today, then cell A2 should show as "Follow-up Required" and cell colour should turn red no. if cell value of A1 is less than 3 days compared to today, no action is required.

    Please help.

    Regards,
    Kiran

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Conditional fomatting with date and time in excel

    Try this:

    Use this formula in cell A2: =IF(A1<TODAY()-3,"Follow-up Required","")
    Select cell A2 and apply conditional formatting using this formula: =A1<TODAY()-3

    - Moo

+ Reply to 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.6.0 RC 1