Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Excel Conditional Formatting: Quick Tips to Get Started

December 9, 2015 by Tyrone Pernsley

Using Excel in the workplace, or for personal needs, is made much simpler when you know who to use all of the tools and features effectively. This week, Learn Excel Now brings you our tips for using Excel conditional formatting. The conditional formatting tool in Excel allows you to apply many different formatting options (such as background colors, borders, and font formatting) to data that meets certain conditions. This makes sorting and recognizing data easier.

In order to set a formatting condition, first select the cells that you want to format. Then on the “Home” tab, click “Conditional Formatting” in the “Style” section. See the image below for a reference point.

excel conditional fromatting image1

For the next step in the process, choose “New Rule.” From there you can select from the following rule types:

  • Format all cells based on their values: With this rule you can choose a 2 or 3 color scale to show which category that value fits closest to (lowest value, percentage, formula, etc). You can also choose from a data bar or icon sets that you can specify the rules of.
  • Format only cells that contain: With this rule, you can pick a certain format for cells that have a certain value between, greater than, equal to, etc. to a certain value.
  • Format only top or bottom ranked values: With this rule, you can format values that are in the top or bottom percentage of the range.
  • Format only values that are above or below average: With this rule, you can format the cells that are above or below the average of the range.
  • Format only unique or duplicate values: With this rule, you can format the cells that contain a duplicate or unique value.
  • Use formula to determine which cells to format: With this rule, you can format cells that contain a certain formula.

excel conditional formatting image2

After creating the rule, it will apply immediately. Any cell that fits the rule will take on the specified format. If none of the cells changed, that means that your rule didn’t apply to any of them. But, as soon as you enter a value that meets the rule, it will take on the specified format.

We here at Learn Excel Now hope you now feel confident in your ability to apply Excel conditional formatting to your spreadsheets. It is our desire to bring you the best advice possible to effectively and efficiently use your desktop features so you can focus on work. Subscribe to our blog to receive weekly Excel tips.

Liked this Excel conditional formatting guide? Have questions? Leave your comments below; we’d love to hear from you.

No anyone else who could use these tips? Feel free to share!

Kevin – Learn Excel Now

Comments

  1. Benjamin Addo says

    February 15, 2016 at 4:58 pm

    Great skills been learnt here thanks for the support

    • Kevin Erdman says

      February 16, 2016 at 9:35 am

      Glad to help!

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In