You can change the way a cell looks based on a formula. In this video, learn how to apply a condition to a cell rule.
- [Illustrator] You can apply Conditional formatting … to a single cell or a range of cells. … Conditional formatting is changing the way a cell looks … based on the contents of that cell. … Start by selecting the cell or range … that you want to test for a certain condition. … Click format, … Conditional formatting. … Make sure you have the correct range selected. … And now you can choose the rule, … click the down triangle … to see some prebuilt rules that you can test on. … You can also click Custom formula is … to create your own formula. … In this case, I want to highlight products … that sold less than 100 units. … I'll click less than, … and in the value or formula I'll type 100. … Now, I can choose how I want it to look. … I'll change the color to red, … and I'll also make the font bold, … so I can see it very quickly. … I'll click done, … and I can add a completely separate rule … or close out of the pane. … I can see my results instantly. … I can get rid of this conditional formatting any time …
- Wrapping text
- Collaborating with others on a spreadsheet
- Freezing and locking panes
- Auto-filling data quickly
- Rotating cell data
- Formatting spreadsheets
- Protecting sheets
- Inserting links
- Filtering views
- Undoing unwanted changes
Skill Level Intermediate
1. Google Sheets Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.