Hello,
Could anyone help me with this, I need to have a different colour for duplicate and a different colour for triplets?
Thanks in advance,
I have attached a sample
Hello,
Could anyone help me with this, I need to have a different colour for duplicate and a different colour for triplets?
Thanks in advance,
I have attached a sample
You will need one rule per color:
Rule 1
Highlight C2:C14 > Conditional Formatting > New Rule > Use a formula
=COUNTIF(C:C,C2)=2
Format: Fill Yellow > OK > OK
Rule 2
Highlight C2:C14 > Conditional Formatting > New Rule > Use a formula
=COUNTIF(C:C,C2)=3
Format: Fill Green > OK > OK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks