I am designing a feedback form where say F7, G7 and H7 are "yes / no"
drop down boxes.

What I would like, is after people have selected "yes/no" from H7, then
if "no" has been selected in F7, G7 or H7 then automatically move
(active cell / curser) to J7.

How is the best way to achieve this please.