View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ember Ember is offline
external usenet poster
 
Posts: 6
Default 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!