Select the cells to be imacted
(I'll assume A2:A10, with cell A2 as the active cell
From the Excel main menu:
<format><conditional formatting>
Formula is: =AND(A2<>"",A2<TODAY())
Click the [Format] button and select the pattern for the cells less than today
Click the [OK] buttons...and you're done.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
