High light only "Expired" names that ARE NOT duplicates

question1.png

Hello everyone ! Im new to excel MACRO and working on a project.

I need to highlight "expired" names that are not duplicates. How can I tell my code to highlight non duplicate "expired" names?
In the example above, I DO NOT want Lauren highlighted because she is a duplicate.

Please Login or Register  to view this content.

Just in case, do you really need a macro for this? You can do this with formulas
Add an extra column with COUNTIF function, and calculated number of entries for each name
Then set conditional formatting for rows where COUNTIF = 1 and Status = Expired.


With a macro,you can do it with something this

Please Login or Register  to view this content.

I think you could probably include the COUNTIF in the CF formula.

This formula would likely do it for conditional formatting:

Formula:

Please Login or Register  to view this content.

In the "applies to", either something like =$A$2:$C$1000 (or whatever row is low enough), or if the list will be really long and growing, you could use =$A:$C

Conditional Formatting, New Rule, Use formula to determine chich cells to format, then paste the formula, click format, choose the fill tab, and pick your color. You can then edit the rule (manage), and edit the "Applies to" field