ISBLANK question conditional formatting
Results 1 to 7 of 7

Thread: ISBLANK question conditional formatting
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default ISBLANK question conditional formatting

    Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format?

    I must be close but am just missing something. I've tried searching with no luck.

    ISBLANK(D3,"")=IF(D3

  2. #2
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: ISBLANK question conditional formatting

    Hi,

    Start at D3 and select your range (I.e. D3:D54), CF, use formula, enter:

    =AND(D3<>"",D3< TODAY())

    Format Fill/Font as desired.
    Last edited by jtakw; Jul 15th, 2019 at 05:07 PM.

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,321
    Post Thanks / Like
    Mentioned
    50 Post(s)
    Tagged
    14 Thread(s)

    Default Re: ISBLANK question conditional formatting

    Try this:

    =AND(D3<>"",D3 < here your date)


    defeated
    Last edited by DanteAmor; Jul 15th, 2019 at 05:08 PM.
    Regards Dante Amor

  4. #4
    New Member
    Join Date
    Oct 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ISBLANK question conditional formatting

    Thanks guys, that worked. I will have to read up on the AND function.

  5. #5
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    301
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ISBLANK question conditional formatting

    Hi,

    below can be an option :

    =AND($D3 <> "",$D3 < TODAY())
    Last edited by Aryatect; Jul 15th, 2019 at 05:10 PM.
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  6. #6
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: ISBLANK question conditional formatting

    You're welcome.

  7. #7
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,321
    Post Thanks / Like
    Mentioned
    50 Post(s)
    Tagged
    14 Thread(s)

    Default Re: ISBLANK question conditional formatting

    Quote Originally Posted by LordEvil View Post
    Thanks guys, that worked. I will have to read up on the AND function.

    A detail, in the condition format you should not put the IF statement.
    If the formula is true, then the cell lights up.

    =AND(D3<>"",D3< TODAY())

    In the previous example, if the 2 conditions are met, it is true.
    Regards Dante Amor

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
  •