Conditional Format of Blank record

R

rhmartin

I am trying to add conditional formatting to a field that has some blank
records. What expression or cell value will highlight the blank
records(dates in this case)? Thanks
 
J

John Spencer

Expression is
[Field] is Null

Then use the background color to set a highlight color.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Excel Conditional Formatting help needed. 1
AMENDMENT to my Conditional Formatting Question 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional formatting for blank cell on report 1
Conditional Formatting Headache 2
Conditional Formatting on client 11
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16

Top