Forum Discussion
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...
- A2 is a cell with a date
Conditionally format with a formula: =$A2<TODAY()
Custom formatting code: "NOW"
A2 is a cell with a date
Conditionally format with a formula: =$A2<TODAY()
Custom formatting code: "NOW"
Conditionally format with a formula: =$A2<TODAY()
Custom formatting code: "NOW"
Patrick2788 Perfect! Thanks.
