Conditional formatting
1. Conditional formatting
To apply conditional formatting to data, open the Format menu and click Conditional Formatting. The conditional format rules panel will appear on the right side of the Sheet. Choose between a single color or color skill style. Choose the range of cells to apply the formatting to by entering the beginning cell address and end cell address. Or click the Select Data Range to click and drag to select the cells to format. In this case, let's make all the cells that fall under 200,000 red. Create a rule or rules by selecting an option from the Format Cells If... Then choose the text format to apply. Click Default to select from the six preconfigured styles, or create a custom style with bold, italic, underline, strikethrough, text color, and cell background color. Click Done to apply the conditional formatting, or click Plus Add Another Rule to add another condition. Rules are applied in order and a range in each cell within it once formatted by a rule will not be changed by subsequent rules. When creating a color scale rule, choose a cell range. Click Default to choose a color scale or create a custom color scale. Choose a minimum value and a maximum value for the scale. A midpoint can also be specified. Click Done to apply the formatting or add another rule to layer more conditions on the data.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.