Forum Discussion

Tanya Armitage's avatar
Tanya Armitage
Copper Contributor
Jul 23, 2018

Conditional Formatting matching items on multiple rows

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 

Formulas & Functions
Need Help

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 25, 2018

    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.