Conditional Formatting lets you fix a set of rules, and format cells that fit the rule in a unique way. This way, you can take a quick look at the spreadsheet, and can focus immediately on the cells you want to focus.
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 ...
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 ...
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 ...
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 ...