Interactive

Analyzing Data in Excel 2016: Use Logical Functions to Apply Conditional Formatting

Biz Library

Updated Feb 05, 2019

Microsoft Office Excel 2016: Part 2 (Intermediate) - The tools available in Excel enable you to create specific rules you can use to apply conditional formatting and to tailor the display of conditionally formatted cells using an incredible array of options. (Use a Formula to Determine Which Cells to Format Rule, Cell References and Conditional Formatting, Guidelines for Applying Conditional Formatting to Cells Basedon Values in Other Cells)

Related learning

Excel 2013 Part 3: Apply Conditional FormattingInteractive ⋅ 6 mins

Formatting a Worksheet in Excel 2016: Apply Basic Conditional FormattingInteractive ⋅ 4 mins

Formatting DataCourse ⋅ 108 mins

SkillPath® Excel 2016 Essentials: Topic 9 -- Conditional FormattingInteractive ⋅ 12 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Biz Library

GLOBAL

BizLibrary is a world-leading eLearning training provider with a library of over 6500 resources available in Go1. The BizLibrary collection contains thousands of employee training videos on key topics your employees need, including business and soft skills, leadership, sales and customer service, HR compliance, IT software, workplace safety and more. With scientifically-proven employee training solutions that engage employees and drive results, BizLibrary online courses appeal to businesses of all sizes. All video content means courses are relatable and engaging, whilst covering essential topics for any organization and any learner. BizLibrary is a US-based provider of business skills, leadership and management training courses, which are all available in the Go1 Content Hub and relevant globally.