Forum Discussion

Robinmf1979's avatar
Robinmf1979
Copper Contributor
Apr 04, 2022
Solved

Conditional Formatting, 3 conditions met in row

Hi,     I need the row highlighted where 3 conditions are the same:    1. YearWeek = YearWeek (Col C) 2. ProductName = Product Name (Col I) 3. Store = Store (Col A)   Example: Rows 45 & 47 ha...
  • Robinmf1979 

    Row#40 and 41 also meet the criteria, why didn't you highlight them?

     

    Select the range A37:O48 and make a New Rule for Conditional Formatting using the formula given below and set the format as per your requirement.

     

    =COUNTIFS($A$37:$A$48,$A37,$C$37:$C$48,$C37,$I$37:$I$48,$I37)>1

     

Resources