North Dakota Blue Book. The North Dakota Blue Book is a series of volumes that contain a compendium of information about the stateâs political, economic, social, cultural, and environmental history, along with its status when each volume was published. Registered Lobbyists.
Adding the First Conditional Format Rule - Checking for Dates 30 days past due. 1  Highlight cells C1 to C4 to select them - this is the range to which we will apply the conditional formatting rules. 2  Click on the Home tab of the ribbon. 3  Click on the Conditional Formatting icon to open the drop down menu.
Accessing the Conditional Formatting Menu. Before entering the Conditional Formatting menu, you need to first select the cell(s) that you wish to apply the formatting to. Next, select the Conditional Formatting option on the Styles tab of the main Home toolbar. This will cause the drop-down menu (shown on the right above) to appear. This menu allows you to select the type of Excel Conditional Formatting that you want to apply to your cell(s). This can be either: 1  Highlight Cells Rules-Apply formatting to cells that satisfy a specific condition (eg.