Conditional formatting with two columns

[Alotheal]

I want to treat two columns as one and compare rows.
I need to look for duplicates but they are dependent on two columns.. I'll try to give a visual example.

Number	Stage	Desc	State	OP	Date
123	Red	Hey!	...	...	...
123	Orange	Hey	...	...	...
456	Green	Cats	...	...	...
876	Blue	Dogs	...	...	...
123	Red	Hey!	...	...	...

As you can see Number "123" and Stage "Red" appeared twice so they will be highlighted. Notice there are other similar Numbers and Stages but both don't match simultaneously. So my goal is to make this happen preferably with a conditional formatting formula.

 

[Joe4]

Use the COUNTIFS formula, counting how many records match both those two fields, and see if it is greater than 1, i.e.
Selecting the range A2:B to the last used row, and using this Conditional Formatting formula:

=COUNTIFS($A:$A,$A2,$B:$B,$B2)>1

 

[Alotheal]

Use the COUNTIFS formula, counting how many records match both those two fields, and see if it is greater than 1, i.e.
Selecting the range A2:B to the last used row, and using this Conditional Formatting formula:

=COUNTIFS($A:$A,$A2,$B:$B,$B2)>1

Thank you, this works very well.

 

[Joe4]

You are welcome.