Format cell based on column of dates

I'm trying to format a singe cell based on if a row of dates is aged more than 3 days.

Column C is for Load Date. Rows C2:C100 may or maynot have a date in them. Cell C101 is a count (=counta(C2:C100) of how many cells above contain data.

I'm wanting to format C101 to turn red if ANY of the dates in C2:C100 are older than 3 days from the current day.

Can someone point me in the right direction?

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread..

http://www.excelforum.com/excel-gene...-of-dates.html

Thread Closed.