To create a custom format for a rule, click Custom Format on the drop-down menu. You can select a built-in color scheme as described above, or create a custom format. A popular technique is to format 'greater than' values with one color scheme, and 'less than' values with another color scheme. We've added a legend in row 2 letting the reader know that the green cells represented scores of 90 or higher.Įxpert Tip: Multiple conditional formatting rules can be created for the same selection. The result of our conditional formatting is shown in the worksheet below. When you make a selection, Excel displays a live preview. In most versions of Excel, the default font and fill colors are Light Red Fill with Dark Red Text. (Excel pre-fills the box with the midpoint of the values of the selected cells.) Then click the little down arrow at right and select a color scheme from the drop-down menu. Step #4: Type the value to format greater than (or less than) in the box at left. For this example, we've selected Greater Than. Click Greater Than or Less Than on the menu.

Step #3: Hover the cursor over Highlight Cells Rules and a fly-out menu displays with various options. The Conditional Formatting menu also displays below. The icon on the ribbon will look different on narrower windows. Step #2: Click Conditional Formatting in the Styles section of the Excel ribbon. Individual cells can be selected by holding down the Ctrl key. Step #1: Select (highlight) the range of cells to conditionally format. We want to conditionally format all scores that are equal to or greater than 90. Our sample worksheet contains test scores for five teams. Steps to Conditionally Format Greater Than or Less Than

Excel greater than and less than range