For the rule type select the first open to check values in the current record.ĥ. The Conditional Formatting rules manager will open. Right click on Current Value and select Conditional Formatting.ģ. This will select all rows under the Current Value heading.Ģ. In this case we’ll click the Current Value heading. If the value is under $100 we’ll highlight the value in red.ġ. Formatting Based on Data within the Controlįor our first example we’ll highlight values in the “Current Value” field. Once I created the database I entered in some sample data (Figure 1). For the purposes of this article I created a new database based off the Desktop Asset Tracking template available within Access 2013. Let’s set up a sample database so we can dive into learning about conditional formatting.
0 kommentar(er)
