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

[JimSeymour]

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 · Accepted solution]

A2 is a cell with a date

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

[#3]

@Patrick2788 Perfect!  Thanks.