Conditional Formatting on Null Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
This worked great! Thanks!

Ember

Harlan Grove said:
...
...

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.
 
Back
Top