How do I create accessible forms in Microsoft Excel?
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| Tip |
|---|
The colors are used only where their section is. This provides a more organized look to the form. |
Rule 5: Always include instructions on navigating and completing the form in Cell A1.
...
Rule 6: Every form input field needs to have a label or instructions visible on the screen. A good way to do this is by making sure that every input cell is next to their label. In our example below, the Manager cell is located next to its input cell.
...
Rule 7: Do not leave any cells blank. Make it so that every single cell has to be filled out.
Rule 8: Input cells should be shaded to make them more visually discernable, using a color other than yellow. It is helpful to subtly shade the background of the input cells, to help them stand out from the rest. Be sure to keep in mind sufficient color contrast between shading color and text color. It is strongly recommended to avoid using any shade of yellow to shade input cells. This is because the box containing an input message for a cell is yellow, which would create color contrast issues.
...
Section 8.2: Data Validation
...
Section 8.3: How to Provide Clear Error Alerts
Error Alerts are a great way to give people some guidance on whether they have filled out the form properly or not. To create an error alert,
Choose a category you want an alert to appear for.
...
4. If the wrong information is typed into the box, your warning should appear.
...
| Info |
|---|
Now we have an error for birthdates. If someone types in a date before or after our age limit or an inaccurate date, they will be alerted. Remember, if an input field is required, the user must be alerted. |
...