Conditional formatting formula/vba

Question

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?

Subodh Tiwari sktneer · Accepted Answer · 2017-07-26 14:37:08Z

1

To achieve this with the help of the conditional formatting, follow these steps...

Select the whole columns B:C.
Home --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> in the box below "Format values where this formula is true", paste the formula given below
Click on Format --> Font --> Choose the Bold italic and set the font color to red or as per your choice --> OK --> OK to finish.

Formula for conditional formatting:

=AND(B1="x",COUNTIFS($A:$A,$A1,B:B,"x")>1)

answered Jul 26, 2017 at 14:37

Subodh Tiwari sktneer

9,9862 gold badges20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting formula/vba

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related