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.
The first rule, in column A, formats future birthdays, and the rule in column C formats cells as soon as âYâ is entered, indicating that the birthday greeting has been sent. To create the first rule: Select cells A2 through A7. Do this by dragging from A2 to A7. Then, click Home Conditional Formatting New Rule.In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.Under Format values where this formula is true, type the formula: The formula uses the TODAY function to see if the dates in column A are greater than today (in the future). If so, the cells are formatted. Click Format.n the New Formatting Rule dialog box, click Use a formula to determine which cells to format. Under Format values where this formula is true, type the formula: The formula uses the TODAY function to see if the dates in column A are greater than today (in the future). If so, the cells are formatted. Click Format.