Results 1 to 9 of 9

Thread: Conditional formatting issues 2.0
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formatting issues 2.0

    Hi,

    Please see screenshot:
    https://imgur.com/WEnzwsS

    I have so many issues with this condiational formatting, now I am facing this. Everything looks perfectly correct to me but the conditional formatting still colors the cell, why?

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,157
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Conditional formatting issues 2.0

    What value do you actually have in the cell?
    If posting code please use code tags.

  3. #3
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting issues 2.0

    This one:
    2019-06-01

  4. #4
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,203
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Conditional formatting issues 2.0

    Shouldnt this just be

    $E$19 < TODAY()

    ???
    Last edited by Special-K99; May 20th, 2019 at 07:34 AM.

  5. #5
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,157
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Conditional formatting issues 2.0

    The TEXT function returns a string, you can't properly compare a string value to a date value.
    If posting code please use code tags.

  6. #6
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting issues 2.0

    I need to compare by year/month and not year/month/day

  7. #7
    Board Regular
    Join Date
    Jun 2018
    Posts
    175
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting issues 2.0

    Any suggestions? I've also tried:
    =$E$19<(YEAR(TODAY())&MONTH(TODAY())) but does not work.
    Last edited by Cameltoe; May 20th, 2019 at 09:19 AM.

  8. #8
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Conditional formatting issues 2.0

    try

    =(YEAR($E$19)+MONTH($E$19))<(YEAR(TODAY())+MONTH(TODAY()))

  9. #9
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,392
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Conditional formatting issues 2.0

    Maybe
    =$E$19<=EOMONTH(TODAY(),-1)
    - 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
  •