13 Less Than A Number

How to highlight cells if value greater or less than a number in Excel?

Permit'due south say you have a tabular array with big amounts of data, to observe the cells with values that are greater or less than a specific value, it will be tiresome and time-consuming. In this tutorial, I will talk nearly the means to rapidly highlight the cells that contain values greater or less than a specified number in Excel.

Highlight cells if value greater or less than a number with Conditional Formatting

1. Select the data range where you desire to highlight the cells that contain values greater or less than a specified value.

two. On the Dwelling house tab, click Conditional Formatting > Highlight Cells Rules, then select Greater Than, Less Than or other options equally you demand.

3. (Here I selected Greater Than every bit an example.) In the popular-upwardly Greater Than dialog box, enter the value in the input box at left, and select the format option in the drop-downwardly list at right as shown below.

Annotation: If you lot want to utilize a custom format, choose Custom Format, then customize your format in the popular-up Format Cells dialog box.

four. The cells that run into the condition you set are highlighted at once.

Notation: If you need to edit the dominion, such as to change the value (450), the relationship (greater than to less than for example), or the range where to apply the dominion, click Conditional Formatting > Manage Rules to bring up the Conditional Formatting Rules Manager.

Highlight cells if value greater or less than a number with Select Specific Cells characteristic

Kutools for Excel offers the Select Specific Cells characteristic to assistance y'all observe multiple values that meet one or ii weather you set at once, delight read on to discover out how to speedily highlight cells that contain values greater or less than a number.

one. On the Kutools tab, in the Editing grouping, click Select > Select Specific Cells.

ii. In the pop-upwards Select Specific Cells dialog box, delight practise equally follows:

In the Select cells in this range box, click the range-selecting push at right to specify the range from where to highlight the cells. Note: To search across the whole sail, click on the sheet tab.
In the Selection type department, select the Jail cell option.
In the Specific type section, set ane or two conditions:
- Click on the drib-down arrow at left side to select a human relationship you need, such as Greater than, Less than, Greater than or equal to, etc.
- Blazon the value in the corresponding box according to your needs.
- Specify the human relationship between the two atmospheric condition (if there are): And or Or.

3. Click Ok to select the cells that see the condition(due south) you set. A dialog box pops up telling you lot how many cells were found and selected.

4. Click OK. Now, you can highlight the selected cells at in one case by giving them a different font color, fill color or other formats.

Annotation: To use the Select Specific Cells feature, y'all should have Kutools for Excel installed in your computer. If you do not have Kutools installed, click hither to download and install. The professional Excel add together-in offers a 30-day free trial with no limitations.

Related manufactures

How To Highlight Cells Higher up/Below Boilerplate In Excel?

In some special cases, y'all may need to highlight or conditional formatting the cells which are above/beneath the average value in a data range in Excel. Here I will tell you how to solve this trouble quickly in Excel.

How To Highlight Cells Based On Length Of Text In Excel?

Supposing you are working with a worksheet which has list of text strings, and now, you want to highlight all the cells that the length of the text is greater than 15. This artical, I will talk about some methods for solving this chore in Excel.

How To Highlight Cells Between Ii Dates In Excel?

If you have a listing of dates in your worksheet, and now, you desire to highlight the cells or rows which are in between two defined dates, the Conditional Formatting of Excel can practice yous a favor. This article will talk about how to apply the Conditional Formatting to highlight the cells or rows between two dates.

The All-time Function Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity past 80%

Reuse: Quickly insert circuitous formulas, charts and anything that you have used earlier; Encrypt Cells with password; Create Mailing Listing and ship emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Information; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Observe in Many Workbooks; Random Select...
Exact Re-create Multiple Cells without irresolute formula reference; Car Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove past Position, Remove Space; Create and Print Paging Subtotals; Convert Betwixt Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort past month/week/day, frequency and more; Special Filter by assuming, italic...
Combine Workbooks and WorkSheets; Merge Tables based on primal columns; Split Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Piece of cake deploying in your enterprise or arrangement. Full features 30-day free trial. 60-day money back guarantee.

kte tab 201905

Part Tab Brings Tabbed interface to Office, and Make Your Piece of work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
Open up and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you lot every twenty-four hour period!

officetab bottom