Basic Table - Conditional Formatting when field is Null or has blank spaces

[cstafford]

I am trying to add some conditional formatting on a simple report and having an issue when the field is Null or is empty but with blank spaces. I want to make this field RED when this condition occurs. 

I trimmed the column to remove blanks spaces and it will not recognize the blank condition

I tried a formula to recognize a Null field, and it will not recognize the condition.

any suggestions?

[LordNeilLord · Accepted solution]

Hey @cstafford 

In the formula option try IsEmpty(Trim([Replen_Day]))

[cstafford]

that worked. Thank you!