Conditional Formatting Overdue and blank dates

[lennox25]

Hi, 

I have this measure for anything thats overdue past today but need to incorporate blank dates?

Conditional_formatting = if(max(Tablet[ Next Visit]) < Today(),"red")

Thank you

[PhilipTreacy · Accepted solution]

@lennox25 

Try this

Conditional_formatting = if(max(Tablet[ Next Visit]) < Today() || ISBLANK(max(Tablet[ Next Visit])),"red")

Phil