Conditionally format cell fill when Values in 2 Columns Duplicate Multiple Rows

[Anne Troy]

The columns are M and N, starting at row 2 and going down ... as far as they go down.

Pizza Cheese
Pizza Pepperoni
Pizza Sausage
Ravioli Cheese
Ravioli Pepperoni
Ravioli Sausage
Pizza Cheese
Ravioli Spinach


In the example above, I need to highlight Pizza Cheese. Whether only the first instance or all instances does not matter.

I do NOT want to add a helper column. I could do that easily.

Help!

 

[slinky]

This should help you out...

Locate duplicates by using conditional formatting - Excel - Office.com

Basically use COUNTIF within a conditional formatting formula..

 

[NBVC]

CF formula:

=AND($M2="Pizza",$N2="Cheese")