Skip to content
Play overlay
Preview this course

Explore Conditional Excel Formatting

Master conditional formatting and let Excel automatically format the appearance of your spreadsheet.

Zenva Academy


£12 inc VAT
Study method
Online, On Demand What's this?
0.9 hours
No formal qualification
  • Reed courses certificate of completion - Free

1 student purchased this course

Add to basket or enquire


Master conditional formatting and let Excel automatically format the appearance of your spreadsheet.


0h 54m
    • 3: Basic Conditional Formatting Rules 07:00
    • 4: Manage Existing Formatting Rules 07:07
    • 5: Highlight Due Dates 07:20
    • 6: Data Bars to Compare Values 06:19
    • 7: Create a Heat Map 03:00
    • 8: Using Icon Sets 08:02
    • 9: Apply Conditional Formatting to a Row 04:28
    • 10: Testing Multiple Criteria 06:39
    • 11: Additional Resources 01:00

Course media


Add more clarity and aesthetic appeal to your spreadsheets by using conditional formatting. With this course, you will learn how to apply rules against your data so Excel can automatically format the appearance of your spreadsheet. Make Excel work for you and increase your productivity with these techniques.

You will learn how to:

  • Create and manage conditional formatting rules
  • Highlight, change color, bold text, and more through established rules
  • Set up data bars, heat maps, and icon sets for more advanced visual aids
  • Automatically format entire rows with your rulesets
  • Utilize multiple sets of criteria for your conditions

Who is this course for?

  • Entrepreneurs looking to effectively use data for business decisions
  • Job-seekers wanting to upskill into Excel for data-related positions
  • Anyone wishing to improve their business productivity
  • Data analysts looking for new ways to quickly customize their reports


  • Basic understanding of Excel formulas and general Excel tasks.

Career path

  • Excel Administrator: £22,379
  • Data Analyst: £36,636
  • Data Scientist: £58,832
  • Data Specialist: £46,152
  • Data Entry: £20,156

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.


Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed


Currently there are no reviews for this course. Be the first to leave a review.


What does study method mean?

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.