If you need to mark some data, for example, best or worst achievement or values higher or lower than some number. To use this function, first, you need to choose "Conditional format" from the "Edit" section:
Then it would be best if you chose the style that you want to use condition that must be fulfilled:
We can choose values:
- greater
- less
- greater or equal
- less or equal
- equal
- not equal
- between
- not between
There are also text functions:
- contains
- not contains
- begins with
- not begins with
- ends with
- not ends with
You can color the first three largest values using conditional formatting and function LARGE, where you must choose range and number, which determines which value from the data set you want to choose.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article