Forum Discussion

JimSeymour's avatar
JimSeymour
Copper Contributor
Mar 11, 2022
Solved

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

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 th...
excel
  • Patrick2788's avatar
    Patrick2788
    Mar 11, 2022
    A2 is a cell with a date

    Conditionally format with a formula: =$A2<TODAY()
    Custom formatting code: "NOW"
Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 11, 2022
A2 is a cell with a date

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

Resources