• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

conditional formatting

conditional formatting tables and matrices in power bi

Conditional Formatting in Power BI Tables and Matrices

May 19, 2022 by Philip Treacy

Conditional formatting in Power BI visuals allows you to draw attention to, or highlight, data in text or numeric fields using color, icons or data bars. You can also assign URL's to fields to make them clickable and load web pages. Let's look at how to apply all of these different types of conditional formatting. …

Read moreConditional Formatting in Power BI Tables and Matrices
project management dashboard

Excel Project Management Dashboard

March 25, 2020 by Mynda Treacy

Managing projects or tasks can be improved with a visual representation of progress and milestones. Thankfully, an Excel project management dashboard like the one below is relatively easy to build, requiring no programming or add-ins. Download Workbook Download the Excel file containing the Excel project management dashboard and step by step instructions. Enter your email …

Read moreExcel Project Management Dashboard
Highlight Selected Cell In Excel and Preserve Cell Format

Highlight Selected Cells in Excel and Preserve Cell Formatting

May 20, 2015 by Philip Treacy

When you select a cell, or cells, in Excel, the row and column headers change color to indicate what you have selected. As you can see here we have selected B2. Or is it 2B? Hmm, 2B or not 2B? If you have a busy sheet though, you may want a more obvious indication of …

Read moreHighlight Selected Cells in Excel and Preserve Cell Formatting
Conditional Formatting PivotTables

Conditional Formatting PivotTables

April 29, 2014 by Mynda Treacy

Conditional Formatting in PivotTables has its ups and downs. Unfortunately I find them mostly ‘downs’ but let’s not dwell on the negative as the few ‘ups’ might still make it worthwhile depending on your needs. The Upside of Conditional Formatting PivotTables When you apply Conditional Formatting to the Values area of your PivotTable the formatting …

Read moreConditional Formatting PivotTables
excel conditional formatting gantt charts

Excel Conditional Formatting Gantt Chart

May 28, 2013 by Mynda Treacy

Gantt charts are handy for planning and managing project tasks over time. They give a visual representation of the whole project, displaying progress to date and work to come. In this tutorial you'll learn how to build an Excel Gantt chart using Conditional Formatting. We’ll also look at how we can highlight tasks that are …

Read moreExcel Conditional Formatting Gantt Chart
Excel Conditional Formatting with Formulas

Excel Conditional Formatting with Formulas

March 6, 2013 by Mynda Treacy

Excel’s Conditional Formatting tool is diverse with loads of built in rules that you simply point and click to use, but I find more often than not that I need to use a formula based rule. I can sympathise if you’ve ever tried to use formulas in your conditional formatting and ended up tearing your …

Read moreExcel Conditional Formatting with Formulas
Excel Factor 10 Conditional Formatting Painting by Numbers

Excel Factor 10 Conditional Formatting Painting by Numbers

August 15, 2012 by Mynda Treacy

This Excel Factor entry was sent in by Rob Anderson of Oxfordshire, UK. Project planning and other tracking worksheets can be enhanced with Conditional Formatting. Rob uses a clever trick to quickly colour code cells using conditional formatting like columns F:M below: Remember painting by numbers? It’s a bit like that. Where 1 = blue, …

Read moreExcel Factor 10 Conditional Formatting Painting by Numbers
Excel Factor 8 Highlight Cells Containing Formulas

Excel Factor 8 Highlight Cells Containing Formulas

August 3, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or a workbook for other’s to use and you can’t password protect it (for whatever reason), then the next best thing is to highlight the cells containing formulas. This is not only an Excel ‘Best Practice’, …

Read moreExcel Factor 8 Highlight Cells Containing Formulas
How to Use Excel Conditional Formatting

How to Use Excel Conditional Formatting

January 12, 2011 by Mynda Treacy

Imagine examining hundreds of rows of raw data in Excel in an attempt to find a pattern or trend.  You’d go mad! Thankfully one of the tools we can use to make this task simpler is Conditional Formatting. The Conditional Formatting features in Excel 2007 are massively improved and now include many default Conditional Formats, …

Read moreHow to Use Excel Conditional Formatting

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.