Highlight cell rules
The Home | Conditional Formatting | Highlight Cells Rules submenu offers eight different options. I’ll discuss the first seven here and then cover the More Rules command later in the chapter in the Custom rules section. I’ll demonstrate the Greater Than and Less Than rules, and then briefly discuss the other rules, since all are applied in the same fashion. The Greater Than-Less Than-Between worksheet in the example workbook has three rules applied to cells D6:D25. Let’s first apply the Greater Than rule to the Work Area section of the worksheet.
Greater Than
As you may expect, the Greater Than rule allows you to apply formatting to cells that contain numbers or dates that are greater than a specific value. Let’s assign a color to every road that is greater than 8,000 miles:
- Select a range of cells, such as J3:J22, on the Greater Than-Less Than-Between worksheet in this chapter’s example workbook, as shown in Figure...
