So I have the days column and fruit column. There's grouping based on days : Monday, Tuesday , Wednesday etc indicated by that grey and light blue color to separate each day. The fruits are grouped by the days.
I want make a single conditional formatting (for
J1:J range) to flag if there's the same fruit on the same day. For example that red font color : 2 apple on Tuesday and 2 banana on Thursday.
if no grouping by days, i can use :
But how to seperate it if they are grouped by days column ? Thanks.