Forum Discussion
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...
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
Thank you so much for this information. I have turned this data into a table (which has helped me use PowerPivot to auto-sum this information) and will sort accordingly, anyway.
I had originally written my formula to the general song of:
=AND($A37=$A$37,$C37=$C$37,$D7=$D$37)
That didn't work...
I tried naming the ranges uniquely using both a table form and a named cell range (not a table). for some reason it isn't working.
Well, at least we think the same. My idea was the same as yours. 🙂
I had originally written my formula to the general song of:
=AND($A37=$A$37,$C37=$C$37,$D7=$D$37)
That didn't work...
I tried naming the ranges uniquely using both a table form and a named cell range (not a table). for some reason it isn't working.
Well, at least we think the same. My idea was the same as yours. 🙂
What I thought that you want to highlight based on 3 criteria that you specify.
Now I understand that it is not what you want and what you want is to highlight all duplicate items if 3 conditions are met each other in the data table.