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:
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.
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
You require a quote for doing it or for directing you on how to do it?
Do you want to achieve this only by Conditional formatting and Excel formulas, or is there a scope for Macro or VBA program here