![]() When finished, click OK.Ĭlicking Custom Format on the drop-down menu displays the Format Cells dialog box containing a subset of the usual formatting options such as font color, background, and border. Then select a color from the drop-down menu. Step #4: Type the value to format greater than or less than if you don't want Excel's pre-filled midpoint number. ![]() Step #3: Hover the cursor over Highlight Cells Rules and click Greater Than or Less Than on the fly-out menu. The Conditional Formatting menu displays. Step #2: Click the Conditional Formatting icon. Individual cells can be selected by holding down the Ctrl key. Step #1: Select (highlight) the cells to conditionally format. How to Conditionally Format Greater Than or Less Than The icon may look different on narrow monitors. The Conditional Formatting icon is located on the Styles section of the Excel ribbon. In our example below we use numbers, but this option can be used on dates as dates are stored as serial numbers. Using Excel's built-in conditional formatting of greater than or less than is easy with its user interface.
0 Comments
Leave a Reply. |