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.
Create a custom date format. If you want to use a format that isnât in the Type box, you can create your own. The easiest way to do this is to start from a format this is close to what you want. Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab.In the Category list, click Date, and then under Type, pick a date format that is close to the format you want. Go back to the Category list, and pick Custom. Under Type, youâll see the format code for the date format you picked in step 4.he easiest way to do this is to start from a format this is close to what you want. Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date, and then under Type, pick a date format that is close to the format you want.