Forum Discussion
Solved
Conditional Formatting with multiple conditions
In the attached file I am trying to figure a way to do the following steps, in said order: Highlight row every 10th day (completed) Compare Column C values for every 10 day range and highlight in ...
As for 2) and 3) you may apply rules with formulas
=(D2=AGGREGATE(15,6,1/((INT((ROW()-2)/10)+1)=(INT((ROW($D$2:$D$1000)-2)/10)+1))*$D$2:$D$1000,1))*(D2<>0)and
=(C2=AGGREGATE(14,6,1/((INT((ROW()-2)/10)+1)=(INT((ROW($D$2:$D$1000)-2)/10)+1))*$C$2:$C$1000,1))*(C2<>"")As for 4) - have no solution so far, not for today...
As for 2) and 3) you may apply rules with formulas
=(D2=AGGREGATE(15,6,1/((INT((ROW()-2)/10)+1)=(INT((ROW($D$2:$D$1000)-2)/10)+1))*$D$2:$D$1000,1))*(D2<>0)and
=(C2=AGGREGATE(14,6,1/((INT((ROW()-2)/10)+1)=(INT((ROW($D$2:$D$1000)-2)/10)+1))*$C$2:$C$1000,1))*(C2<>"")As for 4) - have no solution so far, not for today...
SergeiBaklan This is good. Consulted an excel expert chat (ExcelChat by Got It,Inc), they are generally good but for this they did not have any any solution, wasted good 5-6 hours with them on this over an above trying to figure it out myself.
Really appreciate this.
The 4th one is a brain scratcher.