• 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
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

How to Use Excel Conditional Formatting

You are here: Home / Excel / 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, including colour scales, icon sets and data bars to name a few. More on these below.

Enter your email address below to download the sample workbook.



By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Before you read on, download the practice workbook here. Note: This is a .xlsx file. Please ensure your browser doesn't change the file extension on download.

When to Use Excel’s Conditional Formatting:

  • If you want to be informed in real time
  • Answer questions visually
  • Analyse data: find exceptions, find relationships, find trends, etc
  • Enhance data presentations

You can choose from inbuilt rules like:

  • Top 10 or Bottom 10 using percentages, average or item
  • Greater than, less than or equal to
  • Text that contains a specific word or phrase
  • A date occurring
  • And even identify duplicate values

Or you can insert a formula and create a custom conditional format. More on that later.

Colour coding can be simple like font colour, font style and cell fill, or more elaborate with icons, colour scales or data bars.

Examples

How to Apply Conditional Formatting:

  • Select the range of cells you want formatted.
  • From the Home tab go to the Styles group and select Conditional Formatting.
  • The menu will appear with your formatting options.
  • When you choose one of the options a cascading menu will appear.
  • Depending on which option you choose you will be prompted to make more selections.
  • Note: You can specify a custom format or use one of the defaul formats.  You can choose to format the cell fill, font style, colour, size, bold, italic, underline and more.

Remove Rules:

  • Click the Conditional Formatting command.
  • Select Clear Rules. A cascading menu appears.
  • Choose to clear rules from the entire worksheet or the selected cells.

Manage Rules:

  • Click the Conditional Formatting command on the ribbon.
  • Select Manage Rules from the menu. The Rules Manager dialog box will appear as below.
  • You can change the list of rules displayed by selecting from the ‘Show formatting rules for:’ list.

Guidelines:

1) Conditional formatting is, at its most simple, a format or group of formats. That means if you copy and paste the cell you also copy and paste the conditional format.

2) You can have more than one rule for a cell or range of cells.

3) Rules at the top of the list (as seen in the Rules Manager) take precedence. That is, a rule at the top of the list takes precedence over any rules below it.

4) New rules are added to the top of the list by default.  You can change the order of the rules by clicking the arrow buttons in the Rule Manager.

5) If rules don’t conflict then both rules will be applied. For example; one rule formats the font colour and the other rule is for the cell fill, both rules can be applied.

6) If rules conflict, for example both rules format the font colour, then the preceding rule, the rule highest in the list, will be applied.

How to Use Stop If True

You can see in the Rules Manager above that to the right of each rule there is a check box for ‘Stop If True’.

We mentioned above that rules take precedence from top to bottom. Therefore if you wanted to stop the formatting once a particular rule was ‘true’ you can simply check the box beside the rule in the Rules Manager.

For example if you checked the box on the first rule and it tested ‘true’ Excel would not continue on with the remaining rules.  This feature enables you to avoid rules that conflict by stopping them at the first occurrence that tests true.

Note: this option isn’t available for colour scales, icon sets or data bars.

Custom Rules:

Whilst the built in formats are great, from time to time you might want to do something different.

You can specify custom conditional formats by selecting New Rule from the Conditional Formatting Menu.  The dialog box below will open.

Then select the type of rule you want, and specify your criteria in the edit the rule description.

Note: Different Rule Description options will appear depending on which Rule Type you select.

Most of them are self explanatory except:

Conditional Formatting Formulas

The last Rule Type in the list above is ‘Use a formula to determine which cells to format’.  Basic examples of formulas you can use here are:

=$F35>500 (row 35 is the first row in my table – see example below)

This formula will apply the conditional format to all values greater than 500.

The absolute reference for column F is instructing Excel that the conditional format is dependant on column F.  If you only used a relative reference for the column the formula won’t work properly.

Now, if you’ve been paying attention you’re probably thinking, why would I use a formula to format cells >500 when the ‘Greater Than’ formats are already built into the Highlight Cell Rules menu.

Well, because if you select the whole table before inserting the rule it will highlight the whole row like this:

Here's a tutorial on how to use formulas to set Conditional Formats.

For Extra Credit add Filters to your data and use the formatting as your filter criteria.

How to Use Excel Conditional Formatting

More Conditional Formatting Posts

conditional formatting tables and matrices in power bi

Conditional Formatting in Power BI Tables and Matrices

How to apply conditional formatting to tables and matrices in Power BI. Use color, icons, data bars and URL's.
project management dashboard

Excel Project Management Dashboard

Excel project management dashboard video tutorial covering various techniques including conditional formatting, PivotTables, Slicers, charts and more.
Highlight Selected Cell In Excel and Preserve Cell Format

Highlight Selected Cells in Excel and Preserve Cell Formatting

Use shapes to highlight the selected, active cells in Excel & preserve cell formatting. So you won't lose any conditional formatting, borders, colors etc.
Conditional Formatting PivotTables

Conditional Formatting PivotTables

Conditional Formatting PivotTables values areas will automatically expand/contract as you add new data or make changes to the filters, rows or columns.
excel conditional formatting gantt charts

Excel Conditional Formatting Gantt Chart

You can build a Conditional Formatting Excel Gantt Chart easily with just a few WORKDAY.INTL formulas and relative references.
Excel Conditional Formatting with Formulas

Excel Conditional Formatting with Formulas

Excel conditional formatting with formulas can be super confusing when you don't follow these three simple rules that ensure they work everytime.
Excel Factor 10 Conditional Formatting Painting by Numbers

Excel Factor 10 Conditional Formatting Painting by Numbers

Excel Factor 8 Highlight Cells Containing Formulas

Excel Factor 8 Highlight Cells Containing Formulas

Automatically highlight cells containing formulas in Excel to reduce the chance of them being deleted or over-written

More Excel Posts

tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.
new Excel features

Cool New Features in Excel for Microsoft 365

Cool New Features in Excel for Microsoft 365 including the navigation pane, smooth scroling, unhide multiple sheets and more.
dynamic dependent data validation

Dynamic Dependent Data Validation

Dynamic Dependent Data Validation with dynamic array formulas like FILTER make it quick and easy to set up.
QAT

Excel Quick Access Toolbar

The Excel Quick Access Toolbar is not only a handy for your mouse, but it also enables some super easy keyboard shortcuts.


Category: ExcelTag: conditional formatting
Previous Post:Excel Cell Formatting Tips & TricksExcel Cell Formatting Tips & Tricks
Next Post:Happy 25th Birthday ExcelHappy 25th Birthday Excel

Reader Interactions

Comments

  1. Michael Musonda

    January 5, 2019 at 5:16 pm

    I want to apply some of the skill in my daily work as I have to sort number of records everyday and I have to generate reports – weekly, monthly and yearly.

    Reply
  2. David Broyles

    August 9, 2018 at 10:50 am

    Thank you, you just saved me hours of struggle!

    Reply
    • Mynda Treacy

      August 9, 2018 at 10:58 am

      Glad I could help, David 🙂

      Reply
  3. Uma Prasad

    September 3, 2017 at 5:47 pm

    Hi I am trying to highlight the bars with respect to range of marks in my worksheet. For example marks ranging from 80-100 should have green bars marks ranging from 70-79 should have yellow bars like that. Is this possible to make. I asked one of the experts but he replied that bars formats are already pre defined and we cannot assign different formats to each desired range or value as we expect. Could you suggest on this please?

    Reply
    • Mynda Treacy

      September 4, 2017 at 9:13 am

      Hi Uma,

      That’s correct. You might be able to use in-cell charts in a separate column to your data, as described here: https://www.myonlinetraininghub.com/excel-factor-7-in-cell-charts

      If you get stuck, please post your Excel file and question on our Excel Forum where we can help you further.

      Mynda

      Reply
  4. Nouman Ilyas

    July 28, 2017 at 4:09 pm

    This is awesome website with great learning information. Excel is never so easy to learn until i have reached to this website.
    Thanks to every one involved in providing such a learning platform. This is contributing a lot to build my skills in excel techniques.

    Reply
    • Mynda Treacy

      July 28, 2017 at 5:39 pm

      Thanks, Nouman! Glad we could help.

      Reply
  5. Ismael Shameem eTOWAR

    September 14, 2016 at 9:48 pm

    Thank you for providing so much valuable information.
    Thumbs up, keep it up.

    Reply
    • Mynda Treacy

      September 14, 2016 at 10:09 pm

      Glad we could help 🙂

      Reply
  6. JERALD

    July 26, 2014 at 6:49 pm

    regarding the formula =$F35>500, how to calculate that total amounts (selected)like sum & count.

    Reply
    • Catalin Bombea

      July 28, 2014 at 12:57 am

      Hi Jerald,
      Please use our Help Desk to upload a sample file, with detailed explanations on what are you trying to do.
      Thanks for understanding
      Catalin

      Reply
  7. Michael

    March 3, 2014 at 8:56 pm

    Hi Mynda,
    Is it possible to conditionally format a cell based on its font format? By font format I mean if the cell is either bolded, underlined or italic.

    I’ve found a number of ways to do it using a vba macro but would like to use the ” Selection.FormatConditions.Add Type:=xlExpression, Formula1:='”=A$1=””[Single Rule]””” approach as this seems to update on user interaction.

    What I’d like to do is turn the cells background to orange if the font it italic.

    Many thanks
    Michael

    Reply
    • Catalin Bombea

      March 4, 2014 at 4:22 pm

      Hi Michael,
      Here is a solution that does not use VBA:
      Place the cursor in Sheet1 cell A1.
      Go to Formulas Tab, Define Name: use the name: IsItalic, Refers to: =GET.CELL(21,Sheet1!$A1)

      GET.CELL is an old EXCEL 4 Macro Function, which allows you to find a lot of information from a cell, if the cell has formula, about formatting, and so on. To check if the cell text is bold, (or the first character only!!) use =GET.CELL(20,Sheet1!$A1) in a defined name: IsBold
      Note: To make the formula volatile, in order to update the results whenever excel recalculates, you can use this formula in defined name:
      =GET.CELL(21,Sheet1!$A1)+0*NOW() This 0*NOW() will change the results fron TRUE or FALSE to 1 or 0, but it will provide updating.
      Now, to obtain the info needed for conditional formatting, in B1 place this formula: =IsItalic When you copy this down, because the reference in GET.CELL function for rows is relative, (Sheet1!$A1), even if the formula is the same in all rows, it will work.
      All you have to do now is to set the Conditional Formatting rule, with a simple reference as a formula: =$B1
      Another use of GET.CEll function you can find here: https://www.myonlinetraininghub.com/excel-factor-8-highlight-cells-containing-formulas
      Catalin

      Reply
  8. Krystal

    July 25, 2013 at 1:04 am

    I am trying to use conditional formatting on an excel file that has real time data updating to it. Is this possible?

    Reply
    • Mynda Treacy

      July 25, 2013 at 9:21 am

      Hi Krystal,

      Yes, you should be able to use conditional formatting. If you’re asking if the conditional formatting will automatically be applied to the new data then the best way to do this is by formatting your data in an Excel Table. That way the formatting rules will be copied to the new data.

      I hope that helps.

      Kind regards,

      Mynda.

      Reply
  9. Chee

    May 10, 2013 at 2:40 pm

    Hi,
    I would need to highlight row base on a start and finish date, the row need to be highlight is based on a running date.

    Example, my start date: 27-May-13 and end date: 01-Jul-13, and and i have marked the cells with running calendar date.

    Please assist.

    Many Thanks

    Reply
    • Mynda Treacy

      May 10, 2013 at 3:53 pm

      Hi Chee,

      I’d need to see the Excel file as you haven’t quite given me enough information. You can send it to me via the help desk.

      Kind regards,

      Mynda.

      Reply
  10. David

    May 2, 2013 at 9:26 pm

    Hi, I am trying to use icon sets to show change as represented in a cell (C1) which has a formula =A1-B1 and represents the change between two monthly performance results, with A1 being the most recent month and B1 being the previous result. Is this possible and if so how do I set up the CF rules ???? have been searching for answers but don’t understand the CF formatting rules side of things. Why do they have 67 and 33 percent all the time and or 0’s & 1’s. Thanks David.

    Reply
    • Mynda Treacy

      May 4, 2013 at 8:21 pm

      Hi David,

      Conditional formatting icons work by comparing a value to a range of values. If the value is >=67 percent of the values you’re comparing to it will usually get a green icon, if it’s >=33 it’ll get a yellow icon and when <33 it’ll get a green icon (depending on which icon set you choose).

      To tell Excel which values you want to compare to you first select them before inserting the conditional formatting rule.

      I hope that helps. If you get stuck I suggest you send me your file and tell me what you’d like to see and I’ll endeavour to help you.

      Kind regards,

      Mynda.

      Reply
  11. Pablo

    March 7, 2013 at 3:05 am

    Hi Mynda, I have a doubt about logical functions when I use conditional formatting.

    Giving this example : = AND(A23>111)
    lf I have any letter or text in the cell A23, why does excel say TRUE ?, no matter the letter or the higher the number I put, it always gives me the same answer, is considering the text as numbers ? so I wonder how excel interprets that ?

    thanks
    Pablo G.

    Reply
    • Carlo Estopia

      March 7, 2013 at 6:47 pm

      Hi Pablo,

      It’s sad to say that Texts are interpreted as greater than numbers.
      That’s how it is.

      Cheers.

      CarloE

      Reply
  12. RogerEP

    November 11, 2012 at 12:30 am

    I have a worksheet which has 3 conditional formats. When I copy this worksheet as another within the same workbook (in preparation for generating some reports), I want to turn off the “Stop if True” for just the 1st of the 3 conditional formats — using VBA in my macro. Can this be done? How? Thank you very much. RogerEP

    Reply
    • Philip Treacy

      November 11, 2012 at 9:08 pm

      Hi Roger,

      Can you please send me your workbook so I can see what you have done and work out a solution for you.

      You can use the Helpdesk to create a ticket and attach a workbook to it.

      Regards

      Phil

      Reply
  13. Lars

    July 26, 2012 at 7:59 pm

    Hi,

    I’m wondering if there is a feature in Excel that allows me to use Icon sets in one cell with the data from another cell.

    This is what im struggling with.

    ‘Sheet1’!A1 Name
    ‘Sheet2’!A1 Number from 0-10
    ‘Sheet2’!A2 Number 0 or 1

    I would like to to use X!V icons.

    If Sheet2 A2 is 1, the Icon shown in Sheet1 A1 should be ‘X’.
    If Sheet2 A2 is 0, and Sheet2 A1 is between 5-10 the icon shown in Sheet1 A1 should be ‘!’
    If Sheet2 A2 is 0, and Sheet 2 A1 is between 0-4 the icon Shown in Sheet1 A1 should be ‘V’.

    Br Lars

    Reply
    • Mynda Treacy

      July 26, 2012 at 9:34 pm

      Hi Lars,

      You could do this with a nested IF statement with the AND function like this:

      =IF(Sheet2!A2=1,"X",IF(AND(Sheet2!A2=0,Sheet2!A1<5),"V",IF(AND(Sheet2!A2=0,Sheet2!A1>=5,Sheet2!A1<=10),"!","")))

      I hope that helps.

      Kind regards,

      Mynda.

      Reply
      • Lars

        July 30, 2012 at 3:22 pm

        Thank you,

        But I wasn’t actually looking too use “X”, “!” and “V” as data in Sheet1 A1. I have already predefined the data in this cell. I want to use Icon set (X,!,V) as an indicator of something happening in another cell without changing the predefined data in the cell.

        Lars

        Reply
        • Mynda Treacy

          July 30, 2012 at 11:12 pm

          Hi Lars,

          Excel Conditional Formats doesn’t allow you to create custom icon sets, an alternative is use another cell to generate your ‘custom icon’ using the IF function I suggested.

          Kind regards,

          Mynda.

          Reply
          • lokesh

            August 3, 2012 at 5:36 pm

            mam, i search all website for excel bu i can’t learn corretly, plse tell me hot learn formulas in excel, i am a dataentry operator, i have 5 year experience, but i do not no very well excel. pls help me.how to learn easaly for vlookup, pvote table and formulas for excel

          • Mynda Treacy

            August 3, 2012 at 8:45 pm

            Hi Lokesh,

            You can find a list of Excel Formulas here, including PivotTables and other Excel tools.

            Kind regards,

            Mynda.

  14. Anita

    May 17, 2012 at 8:21 am

    I’m working with a fairly large spreadsheet. In order to focus on the data one row at a time, is there a way so that once a cell is clicked/selected the entire row is highlighted? and revert to no fill once it’s on another cell?

    Thank you!

    Reply
    • Mynda Treacy

      May 17, 2012 at 10:42 pm

      Hi Anita,

      Great question, but a long answer. You can do it using a combination of Conditional Formatting and VBA. I haven’t written a tutorial on how to do it yet but if you send me your file I can insert it for you.

      To send me your file log a ticket on the help desk.

      Kind regards,

      Mynda.

      Reply
  15. Christina Heldman

    May 8, 2012 at 2:22 am

    Please help. I have a column of numbers, day 2 copies day 1 until an actual number is received. I would like the conditional formatting to highlight the cell once hardcoded with a value to keep my place in the spreadsheet. I am sure this is possible I simply cannot select the correct options can someone help?

    Reply
    • Mynda Treacy

      May 8, 2012 at 9:25 pm

      Hi Christina,

      I’m having difficulty picturing your data. Can you please log a ticket on the help desk and attach your file or an example of your data so that I can help you further.

      Thanks,

      Mynda.

      Reply
  16. kholood

    August 28, 2011 at 6:37 pm

    Hi Mynda,

    I’m facing a situation where I need to format the cells of one row based on another row which has percentages. For example:

    Row 7 has: 1, 2, 3
    Row 8 has: 40%, 52%, 118%

    I need to format row 7 (put different colors) based on the corresponding row 8 value.
    Any idea whether its possible, and if it is, how to do it?

    Many many thanks in advance!

    Reply
    • Mynda Treacy

      August 28, 2011 at 9:05 pm

      Hi Kholood,

      Thanks for your question. You can use Conditional formatting to do this:

      In cell A7 apply the following conditional format formula (Conditional Formatting on the menu > New Rule > Use a formula to determine which cells to format):

      Insert this formula:

      =A8=40%

      Then set your colour

      Then do another one for 52% in cell A7:

      =A8=52%

      Then another for 118% with another colour:

      =A8=118%

      Then copy the format from cell A7 to cells B7 and C7.

      I hope this helps.

      Kind regards,

      Mynda.

      Reply

Trackbacks

  1. Excel Student Performance Dashboard • My Online Training Hub says:
    May 10, 2022 at 12:00 am

    […] Conditional Formatting Data Bars […]

    Reply
  2. Finding a Needle in an Excel Haystack • My Online Training Hub says:
    January 12, 2017 at 11:44 am

    […] the Conditional Formatting menu on the Home tab, choose Color […]

    Reply
  3. Count, Sum and Average Colored Cells says:
    November 25, 2016 at 6:09 pm

    […] Before we get started I need to say that this UDF works only with cells that have their background (fill) color changed. It does not work with conditional formatting. […]

    Reply
  4. Creating Excel Charts from Multiple PivotTables • My Online Training Hub says:
    December 8, 2015 at 2:04 pm

    […] A little Conditional Formatting on cells I2 and J2 will turn the font red if a “No” is […]

    Reply
  5. Excel Form Data Validation • My Online Training Hub says:
    July 9, 2015 at 9:39 pm

    […] the data is in your sheet you can use other methods like conditional formatting to highlight errors or unwanted data. But it’s good to stop the errors before they get into […]

    Reply
  6. Excel Find Tool • My Online Training Hub says:
    December 2, 2014 at 10:40 am

    […] list of fruit and we want to colour the font for the instances of Apples in red. One way is to use Conditional Formatting, but we can also use the Find tool. Here’s […]

    Reply
  7. Excel Factor 8 Highlight Cells Containing Formulas • My Online Training Hub says:
    November 19, 2014 at 12:43 pm

    […] Now you have your formula defined you can use it in a Conditional Format: […]

    Reply
  8. Change the Color of Words in Text says:
    September 23, 2014 at 3:45 pm

    […] can’t change the color of only part of the text string you are searching for, but you can use conditional formatting […]

    Reply
  9. How to Use Filters in Excel 2007 • My Online Training Hub says:
    September 15, 2014 at 11:46 pm

    […] Sort by Colour is great if you’re using Conditional Formatting, or even if you just have different coloured text or cell […]

    Reply
  10. Excel Factor 10 Conditional Formatting Painting by Numbers • My Online Training Hub says:
    September 14, 2014 at 10:21 am

    […] Project planning and other tracking worksheets can be enhanced with Conditional Formatting. […]

    Reply
  11. Conditional Formatting PivotTables says:
    April 29, 2014 at 12:43 pm

    […] can actually use any of the built in Conditional Formatting rules covered here, except these ones you can see greyed out in the menu […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

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.