It sounds like you only have one format (highlight) to apply conditionally,
so you should be okay. For the condition, use a formula rather than a value,
with the formula something like =countif(range,this_cell)1

"Abdul" wrote:

I have 18 members in all, each member can hold 2 items, item list contains 25
different items, I want to place something similar to conditional formatting
so that it will highlight if 2 members or more have the same item in their
inventory, conditional formatting allows for only 3 conditions, while having
25 different items means alot of combinations are possible. I want the
program/code or formula to not highlight if a member holds only a unique
selection from the 25 that is not selected by other members. that again is
not possible with conditional formatting.