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.
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.