How to Highlight Cells that are not Between Two Values

Using conditional formatting, you can quickly highlight the numbers with values that are not between two values. Please follow the steps below:

Step 1: Select the data range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Conditional Formatting" command in the "Styles" section;

Step 4: Click the "Highlight Cells Rules" command from the drop-down list, then select "More rules" from the extended list;

Step 5: Set up the rules in the "New Formatting Rule" window;

– In the first box, select "Cell Value";

– In the second box, select "not between";

– In the third box, enter the smaller number (e.g., "$80,178.00");

– In the fourth box, enter the larger number (e.g., "$100,000.00");

Step 6: Click the "Format" button and select the formatting style in the "Format Cells" window, e.g., fill the cells with blue;

Step 7: Click "OK" at the bottom and you will see cells with values that are not between the two values are now in blue.

ExcelNotes