Conditional Formatting matching items on multiple rows

[Tanya Armitage]

Hi I am trying to write a formula for conditional formatting that returns a red filled cell if the item selected matches one selected in the row above, the same row, the row below or the same column. 

I believe an if(iserror(match nested formula will work but I can't seem to make it work for me.

The area that needs to be conditionally formatted is B5:AA14

I would appreciate any help 

[#2]

Hi Tanya,

If I understood your logic correctly the rule formula could be

=(COUNTIF($B4:$AA6,B5)+COUNTIF(B$5:B$14,B5))>2

applied to your entire range.