From the course: Google Sheets: Advanced Topics
Join today to access over 24,700 courses taught by industry experts.
Conditional formatting - Google Sheets Tutorial
From the course: Google Sheets: Advanced Topics
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 scale 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 pre-configured 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 arrange, and each cell within it, once formatted by rule, will not be changed by subsequent rules.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.