Multiple Languages highlighting
May 17, 2023 路 2 min read 路 Excel Formulae I5=SUMPRODUCT(--(C5:C14="red"),F5:F14) I6=SUMPRODUCT(--(B5:B14="tx"),--(C5:C14="red"),F5:F14) I7=SUMPRODUCT(--(B5:B14="co"),--(C5:C14="blue"),F5:F14) BASIC Dim wb as workbook For Each wb In Application.Workbooks If not wb.ReadOnl...
SSai commented

