What is Between in Conditional Formatting?

What is Between in Conditional Formatting?

In Conditional Formatting Between function highlight those cells' or value that is "greater than and less than ", certain value define by us while applying between formulas.

You can use a simple formula that returns TRUE when the value meets those conditions.

Please follow the below images for better understanding.

Click on conditional formating > Highlight cell rules > Between.

By click on Between new window open like below image and you could put value such as I want to highlight (Green Fill With Dark Green Text) those values which are Greater Than 25 and Less than 60 from the cells. 

Note: You can use more than one conditional formatting on specific columns, rows or Values at a time.  

excel conditional formatting formula greater than and less than