Write 2 IF Formula
IF B1 states "NSW" F37 needs to be decreased by 20%
IF B2 states anything else F37 needs to be the original formula
Second Formula
Cells B5-B12, B15-B17, B20-B27, B30-B32, B35-B37, B40-B52, C15-C17
If any of these cells come back blank or with a - the cell needs to be made red