Formula Help

[VPLUMWOOD]

I have a sheet for recording student marks on an exam paper, I then want to link to a tracker to see what knowledge they need further support with. So on sheet 2 I have a list of statements and each statement links to 1 or more of the questions. Is there a formula that I can use to highlight the cell green if they get a specific question correct on sheet 1? I have used a "1" for correct and a "0" for wrong?
Sheet 1

Year 3: Arithmetic Paper (End of Year)

Q1

Q2

Q3

Q4

Q5

Q6

Q7

Q8

Q9

Q10

Q11

Q12

Q13

Q14

Q15

Q16

Q17

Q18

Q19

Q20

Q21

Q22

Q23

Q24

Q25

Q26

Q27

Q28

Q29

Q30

Student Name

Q1.26 + 10 = (N)

Q2. 3 x 4 = (C)

Q3. 22 ÷ 2 = (C)

Q4. 8 X 1 = (C)

Q5. 374 + 100 = (N)

Q6. 162 - 30 = (C)

Q7. 451 + 223 = (C)

Q8. 1/2 OF 18 = (F)

Q9. 389 + 1 = (C)

Q10. 24 + 8 + 8 = (N)

Q11. 804 - 100= (N)

Q12. 5/7 - 3/7 = (F)

Q13. 540 - 7 = (C)

Q14. 27 ÷ 3 = (C)

Q15. 1/4 OF 16 = (F)

Q16. 427 + 500 = (C)

Q17. 1/5 + 2/5 = (F)

Q18. 394 + 30 = (C)

Q19. 325 - 14 = (C)

Q20. 12 x 5 = (C)

Q21.285 + 478 = (C)

Q22. 652 + 133 = (C)

Q23. 48 ÷ 8 = (C)

Q24. 105 - 10 = (N)

Q25. 3/4 of 24 = (F)

Q26. 15 X 4 = (C)

Q27. 1/5 of 85 = (F)

Q28. 67 X 5 = (C)

Q29. 2081 + 333 = (C)

Q30. 9081 - 420 = (C)

1​

1​

0​

0​

Sheet 2

 

[arun_eagertolearn]

Hi

If I have understood the requirement correctly, in sheet1, 1's should be highlighted with a particular colour (say green)

For that, you may use conditional formatting

Home- conditional formatting- highlight cells rules

Please do let know in case this would suffice, happy to share more details if required