View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NM NM is offline
external usenet poster
 
Posts: 51
Default Counting dates with Conditional Formatting


I have 3 columns a,b,c.Column a,b contains dates.The dates in these columns
turn red if it is less than today.Column c is Status field which contains D
or M(M=Match, D=DOne).If the Status field is D the date is no more red even
if it is less than today( I set conditional formatting).Now,I want to count
the number of red dates in cloumn a or b .The status for these dates in not D.