Explore all our learning and teaching solutions

Explore all our learning and teaching solutions

Got a Kanye-sized ego? → Test it on our Ego-Meter
Conditional Formatting in Excel

Conditional Formatting in Excel

  • Report
Author: Pete Dulany

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

See More

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

Questions and Answers

  • momin
    Answers 0
    momin — almost 2 years ago

    conversion of sum f products to products of sums

  • Answer 1
    Bruce Francis over 2 years ago

    Can we get one on Pivot Tables?

      Christine Carwyn
      Christine Carwyn answered almost 2 years ago


Academic Reviews
SOPHIA has reviewed the tutorial and found it academically sound.

Get a great return on your investment.
Our Accounting course is only $329.

Sophia's online courses help save you money, while earning credits that are eligible for transfer to over 2,000 colleges and universities.*