+ Reply to Thread
Results 1 to 2 of 2

Date/turn start date cell red if completion date is blank or 28 day pass the statrt date

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Here
    MS-Off Ver
    Excel 2010
    Posts
    1

    Date/turn start date cell red if completion date is blank or 28 day pass the statrt date

    Working with Excel 2010. I am requiring the ID number in cell a1 to turn red if "u1" is blank or the date is 28 days past the date in c1.
    would you all be able to help..?

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,942

    Re: Date/turn start date cell red if completion date is blank or 28 day pass the statrt da

    Conditional Formatting> New Rule> Use Formula> =OR(ISBLANK($U1), TODAY()> $C1+28)
    Does that work for you?
    Is U1 really blank or does it contain "" or 0
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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