Reputation: 73
I have the following table where people are in either group 1 or 2 or 3.
What I want is to format (highlight) x differently when one person is in more than one group on one day. Is there any possibility to do this neatly without vba based on formulae only? If vba I do not have a nice idea how to approach this without simply browsing the entire table. How should I approach that?
Upvotes: 0
Views: 40
Reputation: 9976
To achieve this with the help of the conditional formatting, follow these steps...
Formula for conditional formatting:
=AND(B1="x",COUNTIFS($A:$A,$A1,B:B,"x")>1)
Upvotes: 1