Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Our table is really starting to come together nicely. But now let's go ahead and add some conditional formatting to our table. And we'll do that in this Difficulty column. So go ahead and click one time on your table to select it, then click once on the first cell and then come down at the bottom and click and drag up, so you can select all of the individual cells in that column. Next, go up to your Table Inspector, and in the Format tab, come down to the section for Conditional Format and click the button for Show rules.
I'll go ahead and move this window up a little bit so we'll be able to see the result as they're taking place. We'll click the dropdown menu for Choose a rule. Next, we need to set what type of logical operator that we want to use. We could have it so a rule is invoked if the data inside of that particular cell is say Equal to or Not equal to some value or is Between some set of values, or we can apply formatting based on the text content inside of the cell.
So in this case, we want to use Text contains. Go ahead and select that option, and then we'll start with Easy. So go ahead and type in E-A-S-Y, for Easy, and then we'll click the Edit button so that we can edit the formatting that is applied if this condition is met. The only formatting that we really want to apply is we want to change the fill color. So go ahead and click the cell for Fill, and let's go ahead and choose this light green color, and we can see that any cell that contains the text Easy is going to show up in this light green color.
Let's go ahead and click the Plus button to add another rule. We can see that iBooks Author automatically reselects the same condition that we had set before of Text contains, and this time we'll type in Moderate. Click the Edit button, change the fill color for Moderate to be a light blue color, click the Plus button to add another rule, and this time we'll type in Hard, click the Edit button again, and this time when we set the fill, we'll go ahead and choose this nice red color.
We'll go ahead and click Select All, and then close our window. We can see now that iBooks Author is automatically coloring the cells based on the text that they contain. To test to make sure this is working, go ahead and click on one of your cells and then type in another word such as changing Hard to Easy, hit the Tab key on your keyboard to jump to another cell, and the cell's color is automatically changed for us. I'll use the left arrow key on my keyboard to jump back a cell, and I'll type in Hard again and then hit Tab again, and now my table is formatted and set up correctly.
The last thing that we want to look at is how we can sort data within our columns, and we'll do that in the next movie.
Get unlimited access to all courses for just $25/month.Become a member
120 Video lessons · 58410 Viewers
119 Video lessons · 67638 Viewers
84 Video lessons · 16911 Viewers
125 Video lessons · 29811 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.