Is it possible to format dates before today to say "Now"

New Contributor

I have a sheet with dates in one column.  I want to be able to sort on this column - but I also want dates before Today() to display as "Now".  Is this possible?

Obviously, I can manually replace the date with the string "Now", but then I wouldn't be able to sort.

I tried poking around with conditional formatting but didn't see a way to do this.


If it matters, I'm using the latest version of Desktop Excel on Windows 10.


2 Replies
best response confirmed by JimSeymour (New Contributor)
A2 is a cell with a date

Conditionally format with a formula: =$A2<TODAY()
Custom formatting code: "NOW"