Results 1 to 4 of 4

Thread: Conditional Format line if date is overdue

  1. #1

    Conditional Format line if date is overdue



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I am looking to use Conditional Formatting to highlight a whole row is a date is approaching or overdue from a date in D2, I would lik to highlight in Orange if one day before the date in D2 and Red if date is D2 has been reached or overdue.

    Does anyone have any iseas at all please.

    Thanks very much.

    Shazz
    xx

  2. #2

  3. #3
    Thanks very much, one question.

    With using these conditional formatting, any blank cells shows the format i.e red, how can I get it so that if a date is not in the cell it just shows as blank.

    Shazz

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,467
    Articles
    0
    Excel Version
    2010 on Xubuntu
    You can add something along the lines of
    Code:
    =and(B2>0,B2<today())
    so that empty cells are omitted

Posting Permissions

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