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.
Conditionally format text (2:12) Use the Quick Analysis tool to conditionally format cells in a range that have duplicate text, unique text, and text thatâs the same as text you specify. You can even conditionally format a row based on the text in one of the cells in the row.onditionally format text (2:12) Use the Quick Analysis tool to conditionally format cells in a range that have duplicate text, unique text, and text thatâs the same as text you specify. You can even conditionally format a row based on the text in one of the cells in the row.