Forum Discussion
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....
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.