Lesson 15: Format the Font color in Excel | Shade a range of cells to any color in Excel

In this lesson, I’m going to be showing you how to:

  1. Format the font colour of a range of cells in Excel
  2. Shade the cells in any colour in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Or go back to:

Lesson 14: How to insert a HEADER in Excel | How to insert an AUTOMATIC FILENAME in the header

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

24 thoughts on “Lesson 15: Format the Font color in Excel | Shade a range of cells to any color in Excel”

  1. Hi Habib,
    I really become an expert in excel after watching your videos and reading your lessons. You know that most people find excel very difficult but if they listen to your tutorials, they will find it easy.
    Wishing you great success in your business and have a great day

    • Thank you very much for the compliments Rania – I’m very happy to hear you are utilising all my video lessons and not just this one. Just so you know, I will be creating tutorials, on Word, Powerpoint, Access, Publisher and many other software soon too. Pass on the word to your friends and family. Thank you for your support. Take care

      Habib (ICT Tutor)

  2. Although I am not new to excel this is beneficial for people who need a refresher. This also helps those who never used Excel and want to learn. Great video.

  3. Thanks, this helped. Your website is a good resource for many out there learning Excel. It’s a valuable skill to have and add to your resume!

  4. This is so useful. I’m still learning lots about excel but I can’t believe how many people don’t know how to use it at all. I think this post will be so helpful to so many people. Thank you for sharing your knowledge.

    • You are correct to say, so many people don’t even know the basics of spreadsheets, this why my tutorials cover the basics as well as the advanced functions of excel. I will be creating many more tutorials.

      Habib (ICT Tutor)

  5. Excel is absolutely a necessity in my line of work! I’m a psychology student and there are data we need to put in excel with regards to our psych tests and measurement tools. Albeit the output we do is pretty straightforward, knowing when to add a bit of color to my reports does make our otherwise routinary reports quite refreshing to see. Thanks for the refresher courses!

    • You’re spot on there Kevin – a bit of colour makes a big impact on the presentation of your spreadsheets. So the format font colour and cells shading feature is simple yet very effective.

      Habib (ICT Tutor)

  6. Hi Habib
    Thank you for the wonderful lessons in excel. This particular video was very simple and straight forward. I like the way you simplified it. I will surely start all over from lesson 1 so that I acquire all the knowledge needed in excel.
    Stay blessed

  7. I’ve always struggled with using Excell and I’m so glad that I now have your tutorials to learn and navigate myself through Excell. Thank you.


  8. Another really good lesson. You have made it easy to follow and it is very informative. People think of excel of being a very difficult program, however by watching tutorials like this, those that want to learn about excel definitely have a great site to visit now.

  9. This is a well-explained tutorial! I want to freshen up on my excel skills, and this is a nice way to do it. Shading cells in color in Excel is a great tool. I can use it to make charts or columns look more attractive.
    Thank you for this great tutorial!

  10. I love your lessons, they are so helpful! I have always struggled using excel and trying to change the font colour within an individual cell I was finding it impossible until I came across your video which broke it down easily.

    Thank you so much Habib

    • Thank you Amy and you are most welcome. I’m happy my tutorial helped you out to format the font colour of cells in excel. I have other tutorials on our site too, which you will find very useful too. Try starting the tutorials from lesson 1.

      Habib (ICT Tutor)

  11. I absolutely love excel, I started using it back in 2000 so it didn’t have as much customization as it does now and it was a little more complex but it is an amazing program. This is a great tutorial, very easy to follow along with. Thanks for sharing!

    • You’re welcome Melissa and thank you for the kind words. All my tutorials will always be easy to follow and in a step by step form. Regards

      Habib (ICT Tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap