Thanks - this works! How can i get it to ignore the blank cells? Thanks again
for the help.

"bobocat" wrote:

try to select the cell
in conditional formating
"Cell Value is" less than =today(), then set format

"KAT" ...
How do I apply conditional formatting to highlight dates that are less
than
todays date (today's date should automatically update to the current days
date) Hope this makes sense. It is for purposes of highlighting expired
qualifications. Any advice would be appreciated.

Regards,