Hello,

I am having issues executing the following properly:

I have a form that will be filled out by an assessor.

If checkbox in D5 is checked (which produces "true" in T5) and a score of 3 is picked from the drop down in E5, then I want D2 to equal 10. I want this to be the same for repetitively down and across to D8 (T8) and E8.

Simply if a box is checked and the score is three in any of those rows (D5 and E5, D6 and E6, D7 and E7, and D8 and E8) then produce a 10 in D2 otherwise produce a 5. Conditionally formatting shows a check if D2 equals 10 and an X is it equals 5.

The rows do not depend on each other, so there will not be a double check for example or anything else if two rows have boxes checked and 3s. I want D2 to stay an X (5) even if all boxes are checked but no threes are entered in column E.