Conditional formatting

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article