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.
2. Using conditional formatting. [This method works only in Excel 2007 and above] Starting with excel 2007, you can use conditional formatting to set cell format codes as well. This means, when the cell value is Y, we can conditional format the cell to show tick mark symbol. All you have to do is define a new rule, and then go to ânumberâ tab and set the format code you want.