Join Jess Stratton for an in-depth discussion in this video Apply conditional formatting, part of Migrating from Google Sheets to Excel.
- [Instructor] Google Sheets allowed you to change…the way cells were formatted based on the data in them.…It was called conditional formatting.…It's called the exact same thing in Excel,…and there's actually many more choices…you can do in Excel.…Let's start with a useful one that easily points out…all the entries that do not have…an email address filled in in this spreadsheet.…I'm going to start by selecting the entire column.…On the Home ribbon tab, I'll click Conditional Formatting,…and from here, I'll click New Rule.…In the Rule Type, I'm going to select…Format only cells that contain.…
In the Format only cells with field,…I'm going to choose Blanks.…The last thing that I need to do…is decide how I want to visualize the blank cells.…I'll click Format,…and now I'll change to the Fill tab.…I'll change a nice bright color…so I can see it easily.…I'll click OK, click OK again,…and now my rule is created.…I can easily and instantly see…which of my customers I need to get an email address for.…
For the next rule, the sky is the limit…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes