In Excel, highlighting some values in a table is very easy. But have you ever tried to highlight all the numbers that are greater than a certain value in Excel? Here are some cute formulas for you to highlight the values greater than a certain value. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- You can use the below formula to highlight the values that are greater than a certain value.
=A1>X
Syntax Explanations:
- A1 – It represents the input values from your worksheet.
- X1 – It specified the criteria value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Refer to the below example image.
- Here we will enter the input values in Column B and Column C.
- Now we age going to highlight the values based on the given criteria in Column E.
- Apply the above-given formula in the conditional formatting option.
- To know how to apply conditional formatting in Excel, just refer to this article: How to Apply the Formula with Conditional Formatting In Excel?
- Finally, it will highlight the result and displayed it as shown below.
Verdict:
From this short tutorial, we have described the simple formulas used to highlight the values that are greater than a certain value in Excel. Hope you like this article. Please share your comments in the below comment section. Thank you for visiting our site!! To learn more, check out Geek Excel *and Excel Formulas *!!
Top comments (0)