can this be done in excel?

Posted By Message

MarathonKnitter
HAPPY

Member since 2/07

17374 total posts

Name:
EMBRACING CHANGE

can this be done in excel?

i'm creating an excel spreadsheet which will include expiration dates. is there a way that i can formulate the cell to alert me when that date has passed?

for example, the next time i open the file... can the dates that have passed be marked somehow so they catch my eye.

i don't need an alert, per se, i just need to be able to have an idea of how many cells have expired when i open the file.

thanks for any and all info.

Posted 9/25/14 1:15 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: can this be done in excel?

I would use the COUNTIF function.

Something similar to:
=COUNTIF(A1:A20,"<"&TODAY())

That's to count up the dates.

Then I would use the CONDITIONAL FORMATING.
This explains it better than I could:
http://www.techonthenet.com/excel/questions/cond_format4_2010.php


Should also ask - what version of Excel are you using?

Message edited 2014-09-25 13:27:11.600000.

Posted 9/25/14 1:25 PM
 

MarathonKnitter
HAPPY

Member since 2/07

17374 total posts

Name:
EMBRACING CHANGE

can this be done in excel?

Thanks!!!

Posted 9/25/14 3:41 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Microsoft Excel. .. question about the program KittyCat 7/25/13 8 Families Helping Families ™
Anyone know how to transfer addresses from Microsoft excel.... jlk51496 1/29/12 2 Families Helping Families ™
Can a Word doc be merged into an Excel doc? NFT Smileyd17 7/9/09 1 Families Helping Families ™
Excel Wizards... nevermind! Lucky09 5/10/08 0 Families Helping Families ™
can you format a table in Word, the same way you can in Excel? randella 6/13/07 3 Families Helping Families ™
my excel freaking crashed- I lost 2 hours worth of work! Beth 1/24/07 8 Families Helping Families ™