Conditional formatting is a built-in Excel feature that—with proper implementation—can provide very useful and responsive feedback to users. By providing dynamic visuals, users will be able to gain instant insights into data and dashboards.
The aesthetic design of a spreadsheet, when done right, can add significant benefits in terms of usability and functionality.
The next few posts will focus on layout. While layout was previously discussed in some detail (listboxes and forms), we are yet to dive into overarching layout ideas and approaches.