Conditional formatting overview

Conditional formatting applies formatting depending upon a cell's value.

  1. Select the range you wish to format.
  2. Choose Formatting → Conditional Formatting.
  3. A cell can have, at most, three conditions.
  4. The conditions are evaluated until one is true. That condition's formatting is applied. Remaining conditions are not evaluated.
  5. Only one condition's formatting will apply to a cell--the results of multiple conditional formats are not "combined" in any way.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.