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.
1 With your dates now in cells B2:B102, select cell B1 and place a label, such as MyDates, in the cell. 2  Format cell B1 as desired. 3  Select the entire range, including the label (cells B1:B102). 4  Using the Name Box (just above the row headers and to the left of the column headers) define a name for the range.here are actually several different ways you can arrive at a solution. The first, of course, would be to simply add a formula in each cell to the right of the dates in column B, and have that formula return a 1 if the date is between E1 and E2, or a 0 if not. You could then sum the column to get the desired count.