Highlight Expired dates

  • Thread starter Thread starter cbfry18
  • Start date Start date
C

cbfry18

I am needing to be able to open my excel sheet and have it automatically
highlight the expired dates. For example, if I opened the sheet on November
10, 2008, it will highlight everything before 11/10/2008. Is this possible?
I would greatly appreciate it!
 
Suppose your dates are in Col A then
select Column A
Choose Conditional Formatting
Choose FORMULA IS in the first drop drown
Paste
=$A1<Today()
Choose the formatting you want
Click Ok and you are done
 

Ask a Question

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.

Ask a Question

Similar Threads

Conditional formatting dates 2
Conditional Formula based on current date 5
Automatically update a cell with a date based on anther cells date 2
Conditional Format (Todays Date) 2
Using IF function to perform calculation after specific date 1
Formula 5
Formatting Problem-Highlighting a cell when date has expired past current date 1
Excel Formula - Count Dates from another Sheet 8

Back
Top