HIGHLIGHTING CONDITIONAL FORMAT RULE

TERI RICE 40 Reputation points
2026-08-05T15:09:27.53+00:00

I am looking for a Conditional Format Rule to highlight certain criteria. Col A (Name) has duplicate values with the same date, but different Types. I need to highlight a certain Type by Name and Date. EXAMPLE: Highlight Type=NM if Name and Date are same.

Screenshot 2026-08-05 110330

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Hendrix 165 Reputation points Independent Advisor
    2026-08-05T15:38:35.7966667+00:00

    Hi TERI RICE,

    Thank you for sharing your request.

    For this concern, you can use this setup:

    • Select the TYPE column (based on your screenshot B2:B9) then go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
    • Use this formula: =AND($B2="NM",COUNTIFS($A:$A,$A2,$C:$C,$C2)>1)
    • Choose your fill color, then click OK.
    • If you want to change the type, for example highlight BC instead, you just need to change from $B2="NM" to $B2="BC"

    Please give it a try and let me know if it works. If you have any questions, please don’t hesitate to reach out in the comments of this post. I'm happy to assist you further.

    Thank you for your patience and understanding. 

    If the answer is helpful, please click "Yes" and kindly upvote it.

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.