Apply Conditional Formatting in Spreadsheets

Automatically highlight cells that meet certain conditions or match specific values.

Required Editions

Available in: Quip desktop app, Quip iOS mobile app, and Quip on web
  1. Select the cell or cells where you want to use conditional formatting.
  2. From the Format menu, select Conditional Formatting. Or, right-click to open the cell menu, and select Conditional Formatting.
  3. Add formatting rules.
  4. Save your work.

To remove conditional formatting from a cell, from the Format menu, select Conditional Formatting. Delete the formatting rules that you want to remove, and then save your work.