Forum Discussion

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

excel

Formulas and Functions

Subodh_Tiwari_sktneer
Apr 04, 2022
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

Subodh_Tiwari_sktneer

Silver Contributor

Apr 04, 2022

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

Robinmf1979
Copper Contributor
Apr 04, 2022
Hi Subodh_Tiwari_sktneer,

Thank you for your support. I appreciate the help.

I didn't highlight the rows because I wanted to provide an example. This workbook has over 19,000 rows of data in it.

I have added the conditional formatting to my spreadsheet. It works perfectly.

Thank you for your response.

I'm a lousy conditional formatting user and appreciate your expertise, very much!

Robin
- Subodh_Tiwari_sktneer
  Silver Contributor
  Apr 04, 2022
  You're welcome Robinmf1979! Glad it worked as desired.
  
  If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.