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