Conditional formatting with date
Results 1 to 3 of 3

Thread: Conditional formatting with date
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2009
    Location
    Lincolnshire, England
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formatting with date

    hi All,

    need a little help please.

    in column A I have several different names, in column B I have a list of dates.

    what I need to do is change the colour of the cell in column D using conditional formatting when the name (lets say David) appears next to a date that greater than 180 days.

    I can get the cell to change based on the name alone however I cant get the date side to change so putting them together is defiantly looking like its going to fail.


    any help would be appreciated

    steve

  2. #2
    Board Regular
    Join Date
    Jan 2014
    Location
    Dublin, Ireland
    Posts
    1,421
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting with date

    greater than 180 days old yes?

    in the conditional formatting section select new rule, then "Use a formula to determine which cells to format", the enter the below formula

    =AND(A2="David",B2 < TODAY()-180)
    then pick your format, then apply it to the area you want.
    Last edited by BarryL; Dec 19th, 2018 at 09:50 AM. Reason: formula cut off... forgot about the space after tags
    Learn something new everyday.

    be sure to use code tags

    Code:
    [ code ]
    [ / code ]
    ' no spaces

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,594
    Post Thanks / Like
    Mentioned
    444 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Conditional formatting with date

    Select D2 to the last row & use this formula
    =AND(B2< TODAY()-180,A2="David")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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