Conditional Formating

[uniden32]

I've got three Columns

Column A (Names) has individual's names
Column B (Table Numbers) has numbers 1-48
Column C (Seat Numbers) has numbers 1-10

I want to do conditional formating to highlight any ROW that has identical Table Numbers (Column B) and Seat Numbers (Column C)

So, if there were two rows with Table 24 (Column B) AND Seat 10 (Column C) it should be highlighted.

 

[elmer007]

You can add a fourth column (column D) that is used to combine the table and seat information, then use conditional formatting to highlight the duplicates.

Cell D2 formula: =B2&C2

Copy this formula down the entire column.

Highlight Column D and go to Conditional Formatting > Highlight Cells Rules > Duplicate Values


So, if two people are assigned to table 24 and seat 10, then their column D values would both be "2410" and would be highlighted as duplicates.

 

[AlphaFrog]

Select Columns A,B,and C

Use this as a Conditional Formatting Formula
=COUNTIFS($B:$B,$B1,$C:$C,$C1)>1

 

[uniden32]

Thank you very much AlphaFrog, worked perfectly.