| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| ISO smallest passive / do nothing formula for formatting null.. | Excel Discussion (Misc queries) | |||
| Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
