|
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? |