B - Auto detect inputs by cell color

This method is recommend if the input cells are spread around your spreadsheet. It requires your prospective input cells to be formatted with a specific cell color before the SpreadsheetWEB Wizard is started.

At first, all input cells need to be formatted with a specific color. In this example, we use red.

Auto detect by cell color 1

 

In the Wizard, you click the option button next to "Auto detect by cell colors".

Select Input Cells

Use the colored button Colered Button - Yellow to select the color of the input cells or, alternatively, use the dropper Dropper to pick the color of a cell in your Excel spreadsheet. In both cases, the colored button will change its default color (yellow) to the color you have selected. In this example, the colored button turns red Red colored button.

Then click the Add to Palet button. You will see that the color you have selected for your input cells will appear in the palette (i.e. Palet). If you have accidentally selected a wrong color, simply click Empty palet to remove a color.

Click "Next" to get to the next step.