Apply classic conditional formats
To apply single-color/classic conditional formatting,
1. Click on the Format menu.
2. Select the Conditional Formatting option.
3. Click on Classic from the drop down.
4. Once the Conditional Formatting window appears, select the range of cells you want the conditional formatting to be applied to.
5. You can format the cells based on cell value, text, date, cell content or a formula.
6. You can specify how you want the cells to be formatted, by customizing the color, font style, font size etc.,
Related Articles
Apply color scales as conditional formats
To apply color schemes as conditional formatting, 1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on the Color Scales option from the drop down menu. 4. In the dialogue box that appears, select the range of cells ...Apply color scales as conditional formats
To apply color schemes as conditional formatting, 1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on the Color Scales option from the drop down menu. 4. In the dialogue box that appears, select the range of cells ...Manage Conditional Workflows
Edit a Conditional Workflow From the Navigation toolbar, select Automation and choose Workflows. Select the conditional workflow you wish to edit. Click Manage Workflows on the top-right and select Edit. Note: You can edit a workflow only when in ...Conditional Assignment - Overview
What is conditional assignment? Conditional Assignment solves the time-consuming problem of assigning apps individually to users, by automating the task based on preset conditions. The conditions are triggered whenever confirmed users are ...Change/edit the conditional formats already present in a sheet
To manage conditional formatting: On the menu bar, click Format > Conditional Formatting > Manage Rules. View a rule that has been created in an expanded or a collapsed mode. Choose to edit, copy or clear the rules that have been set and listed under ...