---
schema_version: "1"
id: b7df038eb87a6d9473723cbd4ce1e36604caa56f897fa853d04251444c58f0fe
title: Apply Conditional Formatting in Spreadsheets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_use_conditional_formatting.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_use_conditional_formatting.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e5150b7de7af07f0ee7ef74f6a294f412063eb5e913cf659b04652c9541462e4
description: Automatically highlight cells that meet certain conditions or match specific values.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# Apply Conditional Formatting in Spreadsheets

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

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Quip desktop app</strong>, <strong>Quip iOS mobile app</strong>, and <strong>Quip on web</strong></td></tr></tbody></table>

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.