Re: can this be done in excel?
Posted 9/25/2014 1:25:48 PM by nrthshgrl

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?
Print Post      Close Window