Forum Discussion
Conditional Formatting, 3 conditions met in row
- Apr 04, 2022
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
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
- Robinmf1979Apr 04, 2022Copper Contributor
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_sktneerApr 04, 2022Silver Contributor
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.