Add simple automations to MS Excel.

General information for the business: Application and Desktop Virtualization
Industry: Technology
Description of excel work: I'm trying to create a simple tool to give away to application virtualization professionals.

I'm using Excel to map the steps in a flowchart using conditional formatting (as you answer yes/no it moves you to the next question/cell).

At the moment I have a colour showing which question you need to answer next (grey), but i'd like it to move to the cell as well. also once a deployment option has been identified (it changes the cell colour) i'd like the focus to move to the next blank row.

Finally I'd like a summary page to show a count of how many rows are coloured red, blue etc. across the three tabs, desktop, web and browser.

I'm attaching what I've done so far and you can see the results so far on the Web Application tab. Just add an application name, then move to the first question to answer Yes/No.

This is the flowchart i'm following:
https://www.algiz-technology.com/wp-content/uploads/2017/10/App-V-Compatibility-Tool-5.1-October-17.pdf

Any suggestions on making this more robust so that users don't break it most welcome, and there's scope to keep developing it once its released.
Extra notes: