This is probably a basic excel question, but I need to format cells to show text in red when the date in the cell is earlier than the current date. Thanks in advance.
You've really answered your own question here.
You do need to use conditional formatting which is on Format. Conditional Formatting, Then cell value is less than now() and set condition to red
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.