Conditional Formatting is a feature in Excel that allows us to change the format of cells based on a set of rules or conditions. In this tutorial, we are going to highlight the values between two numbers in Excel. 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
Generic Formula:
- Use the below formula to highlight the dates with the next N days.
=AND(A1>=lower,A1<=upper)
Syntax Explanations:
- AND – This function will check multiple conditions and returns *TRUE *if all the conditions are evaluated as true otherwise returns FALSE. Read more on theAND Function.
- A1 – It represents the input 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.
Example:
Refer to the below example.
- Here, we will enter the input values in Column B to Column E.
- Now we are going to highlight the numbers between the two values.
- So 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, we will get the result as shown below.
Wrap-Up:
This tutorial described the simple formula to highlight the values between two numbers in Excel. If you have any issue regarding this article or any unresolved query , please comment in the comment box below. We will assist you. Thank you for visiting our site!! To learn more, check out Geek Excel *and Excel Formulas *!!
Top comments (0)