Conditional format to exclude blanks

[Meena80]

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. 

[Jihwan_Kim]

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]

Hi,

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