Conditional Formating

uniden32

New Member
Joined
Sep 19, 2010
Messages
22
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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.
 
Upvote 0
Select Columns A,B,and C

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

Forum statistics

Threads
1,223,170
Messages
6,170,473
Members
452,330
Latest member
AFK_Matrix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top