Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hi there
    I'm struggling a bit with conditional formatting (and it should be fairly simple)
    I have a list with dates..
    I want the dates that are late shown up in red

    Today (March 17) should show up in white
    tomorrow till 30 days from now shows up in orange..
    yesterday and before should show up in red
    (the shading that is)

    Also in which order do they have to be

    Thanks heaps !!!!!

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    For the past dues:
    =A1<TODAY()

    For the tomorrow + 30
    =AND(A1>TODAY(),A1<=TODAY()+30)

    For today:
    You don't need one unless you've already colored the cells. If you did color the cells
    =A1=TODAY()

    The order won't matter since the 3 conditions won't overlap.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I have been struggling with this. I have attached a small part of the spreadsheet.
    It shows red where there is nothing, which at least is a start

    Thanks so much
    Attached Files Attached Files

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I assumed there was a date in each cell.
    Use this for the overdue CF
    =AND(F5<TODAY(),F5<>"")

Posting Permissions

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