Formula Help Needed (Sum and If Then)
Only need this to work now:
Now after that I need
If any answer = 1 then change that Cell to red along with the original
number that corresponds with it. Else change cell to green.
Example:
Cell E3 and A2 would be red cells
Cell E5 and A1 would be red cells
Cell E7 and A6 would be red cells
|