Results 1 to 5 of 5

Highlight cells on 20 days from birthday

Threaded View

  1. #1
    Registered User
    Join Date
    05-10-2011
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    27

    Highlight cells on 20 days from birthday

    I have an excel spreadsheet with about 50 names. One of the columns on the spreadsheet is labeled, "Birthday." I am trying to figure out how I can program this spreadsheet to cause the cell to change it's background color so that when I glance at the spreadsheet I can tell whose birthday is 20 days out from the day that I am looking at the spreadsheet. In other words, today is May 11th. I would like to open up the spreadsheet today and have any birthday 20 days or less out from today have the cell highlighted so that I can easily pick out whose birthday is coming up. Then after the birthday date is over, have the cell go back to it's normal color.
    Attached Files Attached Files
    Last edited by Lynn McCurdy; 05-12-2011 at 01:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1