+
Conditional Formatting in Excel

Conditional Formatting in Excel

Author: Pete Dulany
Description:

By the end of this learning packet, viewers will be able to:

 * See a real example of how conditional formatting works

 * Use conditional formatting in Excel 2010 to highlight a trend of data

 * Manage conditional formatting rules

 * Clear cells of any conditional formatting

 

Need Excel / Office training or other professional development?  Contact me at Pete@DulanyConsulting.com

Learn about Microsoft Excel's Conditional Formatting feature to see patterns in data that otherwise might not be seen.  Appropriate for computer science classrooms, financial / accounting settings, science teachers working with lab data, and others.

(more)
See More

Try Our College Algebra Course. For FREE.

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial

See conditional formatting in action!

This serves as a basic introduction to Microsoft Excel's conditional formatting feature.

Source: Prepared by Pete Dulany of Dulany Consulting, Inc. 2011

Link to Microsoft Excel file for demonstration purposes

Click here to download the Microsoft Excel file used in this example to try out conditional formatting.

Source: Prepared by Pete Dulany, Dulany Consulting, Inc. 2011