How to highlight data greater than 100 and less than 200 in excel

How to highlight data greater than 100 and less than 200 in excel

1. First create a new form and fill in some data

2. Then, select the data, click Conditional Formatting - Highlight Cell Rules - Between

3, then fill in 100, 200 , click OK

#4. Finally, you can see the effect.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to highlight data greater than 100 and less than 200 in excel. For more information, please follow other related articles on the PHP Chinese website!