Conditional Formatting - dates
supposed that the column A contain the date,
Select Column A
condition formating
Formula is =and(a1<today(),isblank(a1)=false))
"KAT" ...
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,
|