Conditional Formatting on Null Value
 

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!

Conditional Formatting on Null Value
 

formatconditional formatting, formula is

=$D$5=""

format pattern as you like


--
Regards,

Peo Sjoblom



"Ember" wrote in message
...
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!

Conditional Formatting on Null Value
 

"Ember" wrote...
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.

Conditional Formatting on Null Value
 

Thanks, tried that one and it did not work.

Ember

"Peo Sjoblom" wrote:

formatconditional formatting, formula is

=$D$5=""

format pattern as you like


--
Regards,

Peo Sjoblom



"Ember" wrote in message
...
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!

Conditional Formatting on Null Value
 

This worked great! Thanks!

Ember

"Harlan Grove" wrote:

"Ember" wrote...
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.