Forum Discussion

Meena80's avatar
Meena80
New Member
3 years ago

Conditional format to exclude blanks

Hello,

 

I am hoping I can get some help with conditional formatting. I have currently used this formula:

CE date= if(FIRSTNONBLANK('Table'[expiry date],TODAY () )<TODAY (), "red", lightgreen")

 

Above works fine, however, the blank cells are taking the red colour as well. And I want any cell with a blank value to be grey or no colour. 

what do I need to add to get this formula to work the way I want it to? 

Thank  you in advance. 

Need Help

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, but please try something like below.

     

    CE date =
IF (
    NOT ISBLANK ( 'Table'[expiry date] ),
    IF (
        FIRSTNONBLANK ( 'Table'[expiry date], TODAY () ) < TODAY (),
        "red",
        "lightgreen"
    ),
    "black"
)
    • Meena80's avatar
      Meena80
      New Member
      3 years ago

      Hi,

       

      Thank you for your prompt response. I tried the formula and the blank cells are still picking the red colour. Thanks