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.
This is useful because conditional formatting is best understood by testing it on data you already have. While you can apply conditional formatting to empty cells, it is easiest to see if the formatting works by using pre-existing data. 2. Click the cell you want to format. Conditional formatting allows you to change font style, underline, and color. Using conditional formatting, you can also apply strike-through as well as borders and shading to the cells. However, you cannot change the font or the font size of the contents in the cell. 3. Click Format > Conditional Formatting to begin the conditional formatting process. In Excel 2007 this can be found under Home > Styles > Conditional Formatting. 4. Click Add >> to use two conditions. For this example, two conditions are used to see how each one plays off the other.