Hi guys,
Need your help! what will be the formula on this scenario? I have 2 sheets (1 for BIN LOCATION and the other one was DATA SOURCE. From data source the cell of BIN LOCATION sheet will be filled with the color of the said LEGEND below. For exp. BIN LOCATION "ATH-A63-01 with the remarks...