I've got a list of people who do courses. Some of these courses are repeated and so the user doesn't want them counted again. I got a great formula here from Ejgil Hedegaard - thanks again! (Data Entry Sheets - Column I) that does just that. Some of the courses only need to be entered once. In the Certification Current column I have a formula that basically tracks if the Renewal date is within 720 days of the date in M1. However how can I modify the formula so that it (a) marks expired entries as "Expired" e.g. on Row 17, the course has been done twice so it should only be counted once - this entry is "expired!. Secondly how can I apply conditional formatting that only flags entries where (a) the course date and renewal date are NOT the same (if they are the same they do not need to be renewed and it's up to date) (b) course is NOT marked as expired (as per the previous formula) (c) it's marked as No. Basically the user only wants to see colour on the entries for renewable courses where the renewable date is within the date limit and where it's the most recent course done by the person and is not a once off course...thanks !