Type formulas like: =SUMIFS(D:D, C:C,{"US*","UK*"}) =SUMIFS(A:A,B:B,"Pending",C:C,"Hello") =COUNTIFS(A:A,"Pending",B:B,100) =IF(A1<90,"Pass",IF(A1<100,"Fail","Else")) =IF(AVERAGE(A1:A3)>90,"High",IF(SUM(B1:B3)>0,"Medium","Low")) =IF(A1<90, {"Pass","Fail"}, 100) Color rules: • SUMIFS / AVERAGEIFS / MAXIFS / MINIFS: - Color1 = sum_range - Each (criteria_range, criteria) pair gets its own color - If criteria is an array (e.g. {"US*","UK*"}), the criteria_range and the whole {"US*","UK*"} share one color • COUNTIFS: - Each (criteria_range, criteria) pair gets its own color (same logic with arrays) • Multi-IF chain (two or more IFs): - Color1 = first IF branch - Color2 = second IF branch - Color3 = ELSE • Single IF: - Color1 = condition - Color2 = value_if_true (including arrays like {"Pass","Fail"}) - Color3 = value_if_false • Other single functions: each argument gets its own color. • Nested non-IF functions: whole function calls are colored.