conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet on which i enter in a particular date into a cell. I want that
cell to change colour after 7 days has passed so next time i open excel up i
can see which dates have expired.

Also i want all of the dates that expire to come up in another sheet

Help on this would be great.
 
The conditional formatting can be achieved with a formula of say

=A1<TODAY()-7

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

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

Excel Formula - Count Dates from another Sheet 8
Adding an alarm 2
Conditional formatting dates 3
Matching Cell Colors (Cond. Formatting) 1
Conditional formatting dates 2
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
Conditional Validation In Excel 1
Send e-mail based on condition 1

Back
Top