excel conditional formatting and multiple conditions code example
Example: multiple if condition in excel
IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))