Conditional Formatting on Null Value

[Guest]

I have a field which is formatted to be a date field (D5) and another field
which tracks if follow up is needed (G5). I want to use conditional
formatting to highlight G5 if D5 is null, meaning no date has been entered.

Pulling my hair out as I can't quite find the right formula or words to tell
it to look for nothing.

Any help would be appreciated!

 

[Peo Sjoblom]

format>conditional formatting, formula is

=$D$5=""

format pattern as you like

 

[Guest]

I have a field which is formatted to be a date field (D5) and another field
which tracks if follow up is needed (G5). I want to use conditional
formatting to highlight G5 if D5 is null, meaning no date has been entered.

....

Two ways, depending on what you mean by 'null'. If you mean D5 contains
nothing, then use either =COUNTA(D5)=0 or =ISBLANK(D5). If you mean D5
contains nothing OR evaluates to "", use =COUNTBLANK(D5)=1.

 

[Guest]

Thanks, tried that one and it did not work.

Ember

 

[Guest]

This worked great! Thanks!

Ember

...
...

Two ways, depending on what you mean by 'null'. If you mean D5 contains
nothing, then use either =COUNTA(D5)=0 or =ISBLANK(D5). If you mean D5
contains nothing OR evaluates to "", use =COUNTBLANK(D5)=1.