Microsoft Excel: Conditional Formatting

Automatically format cells based on their values or their value in relation to other cells

One Hour, One Topic, Lots of A-ha!s

Conditional Formatting is formatting that is automatically applied based on whether or not certain conditions are met – conditions that you determine. For example, you could ask Excel to use a different format to identify largest values, duplicate values, or cells containing certain text. You can also tell Excel to create a jazzy little visual within your data to help you quickly see trends. In this session, I’ll show you how to set up conditional formatting, some of my go-to conditional formats, their results, and how to manage them once they’re created.

Course Curriculum

Your Instructor

Janet Jackson
Janet Jackson

Janet Jackson founded Organization Solutions in 2001, with a simple mission to help others become more organized. It has since evolved into a successful consulting practice helping businesses and organizations implement more efficient workflow processes and business solutions. The launching of this new site “A Better Way To…” is designed to allow you to benefit from Janet’s solutions and training in a virtual setting.

With a bachelor’s degree in Business Administration from Taylor University and second major in Psychology, she combines her education, experience, profound knowledge of Microsoft Office© and natural gift for organizing to bring increased efficiency to individuals and organizations. Her clients include government agencies, small business, non-profit organizations and manufacturing operations.

Janet’s professional and community associations include the National Association of Professional Organizers (NAPO), NAPO Golden Circle Distinction, BBB Accreditation and Women in Business Networking.

Whether working with individuals to help them manage their day or with organizations to find process improvements, there is a common thread you will find in whatever Janet does, and that’s helping you find a better way.

Get started now!