Conditional formatting

[t1o9n9y1]

[TABLE="width: 500"]
<tbody>[TR]
[TD]JOB[/TD]
[TD]PERSON[/TD]
[TD]ISSUE[/TD]
[/TR]
[TR]
[TD]One[/TD]
[TD]TPK[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]One[/TD]
[TD]TPK[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Two[/TD]
[TD]TPK[/TD]
[TD]B[/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to change the colour of a cell if the values from both the 'PERSON' and
'ISSUE' columns match up. So because there are now two rows meeting the same criteria,
I want the cell with person in it to change to orange.

I've tried conditional formatting but it seems pretty limited, unless I'm looking at the wrong thing.

Thanks for you help.

 

[Fluff]

In CF > New rule > Use a formula > Select the format.
=COUNTIFS($A:$A,$A2,$B:$B,$B2)>1

 

[t1o9n9y1]

Would it also be possible so that if there is a single duplicate, it'll turn orange. However, if a third duplicate occurs, it'll turn red? Can that be done with this formula?

 

[Fluff]

You need to set 1 rule for each colour, so add another rule with the same formula but change the 1 to 2.
Make sure that the rule for red is above the rule for orange

 

[t1o9n9y1]

Okay. I can't quite get the formula to work. That table was just an example and doesn't fully reflect the actual table. So, this is what it currently looks like...
PERSON (G5-G30) ISSUE (I5-P30)

Each cell within the columns have a drop down menu. When the PERSON selection and the ISSUE selection appear together more than once, that's when I want the colour to change.
Would the formula you provided still work?

Thanks so much for your help by the way.

 

[t1o9n9y1]

[TABLE="width: 500"]
<tbody>[TR]
[TD]PERSON[/TD]
[TD]ISSUE[/TD]
[/TR]
[TR]
[TD]TPK[/TD]
[TD]LATE[/TD]
[/TR]
[TR]
[TD]TPK[/TD]
[TD]LATE[/TD]
[/TR]
[TR]
[TD]TPK[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]TPK[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]TPK[/TD]
[TD]LATE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[t1o9n9y1]

That's more accurate I think. The PERSON column goes from cells G5-G30 and the ISSUE column goes from cells I5-P30.

 

[Fluff]

Can you please post some sample data, there are some add-ins available here to help with that. https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[t1o9n9y1]

I can't seem to get MrExcel to work.

The table is identical to this...
[TABLE="width: 500"]
<tbody>[TR]
[TD]... (A4-B30)[/TD]
[TD]... (C4-D30)[/TD]
[TD]... (E4-F30)[/TD]
[TD]Person (G4-H30)[/TD]
[TD]Issue (I4-P30)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TPK[/TD]
[TD]Late[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TPK[/TD]
[TD]Late[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ND[/TD]
[TD]Late[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TPK[/TD]
[TD]Absent[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ND[/TD]
[TD]Absent[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


So because the person and issue match in the top two rows, I want that to highlight.
I have been using the duplicate function in conditional formatting, but it seems to only work based on
one column. I want it to read both columns and when the same entries appear in another row, I want it to be highlighted.

 

[Fluff]

That is just confusing me even more

Is "Person" a single column or 2 columns?
Is "Issue" 1 column or 8 columns?