Hi I have a training workbook that has 2 columns per person for capturing training dates. In the pic the cells in Column I are populated with M or M* column J is used for entry of dates when training has been completed. Column J is conditionally formatted to turn green if within date and red if out of date - my problem is my countif formula in I32 ( =COUNTIFS(J115:J128,">1",$A115:$A128,"eLearning",I115:I128,"M") works but i would like it not to count dates that are in red. Is there a simple way to do this?
Thanks in advance for any help
Capture.JPG
Bookmarks