How can I write a formula or an argument to highlight a date when.

saffield · Feb 24, 2005

it is past the current date

Jason Morin · Feb 24, 2005

=IF(A1<TODAY(),"Past Due","")

where A1 holds the date.

HTH
Jason
Atlanta, GA

Display weeks from a Milestone	0	Dec 7, 2021
Making "Change Highlighting" feature darker	1	Feb 14, 2020
How to paste this down?	3	May 15, 2022
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell.	2	Dec 3, 2013
Change Color of Cell based on Date and today's date.	1	Jul 11, 2012
Conditional Formatting	6	Apr 29, 2013
Paragraph numbering in Word	1	Mar 6, 2022
AppleScript - How do I select a text ?	1	Sep 21, 2020

Ask a Question