How To Calculate RGB Colors In Excel? – Excel Challenges

In previous episode Excel Author Jordan Goldmeier challenged you on ColorIndex property. Did you answer that? Hope you found that interesting as it is always good to learn new things in Excel. Even in this episode, Jordan continues to challenge you a bit more in Excel.

Get Ready Folks!

Last Week’s Challenge

First, let us rewind the previous episode’s challenge. Jordan asked “The colors in Excel’s internal palette can be retrieved using the ColorIndex property. How many colors are available in total?”. Have you answered this and hoping to be the winner? Let us look in to it!

Correct Answer From Last Week’s Challenge

Correct Answer is 56 (or 57) Colors. Confused? Do not worry. Jordan explained that, ‘clear’ is also a color and it can also be set as a property. He also mentioned that, there are always mixed responses regarding this. So, Jordan considered 56 or 57 as the right answer. It is cool, right?

So, who is our winner? Winner is Sridhar Belide. Wow Sridhar! You won the free registration for Mynda Treacy’s class sponsored by Congratulations!

How RGB Is Calculated In Algebraic Terms?

Jordan wants to continue the Color theme even in this episode. Looks interesting! So, here comes this week’s Excel Challenge,

“Excel stores colors as numbers. For example, RGB (130, 210, 11) =774786. How is this calculated?”

This question is based on the inspiration of Chris Newman’s post in So, Jordan is looking for the algebraic formula which is used to calculate RGB to get that large number (774786 in our example). What are you waiting for? Hurry Up!

This is really an interesting challenge. Go ahead and comment your answer in Excel TV blog post or Facebook. You can even tweet to @ExcelTV. Come On!

Sridhar Belide


You may also like

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

October 26, 2014

Monte Carlo Simulation Formula in Excel – Tutorial and Download

September 17, 2012

The Excel Rollover Mini FAQ
    • Congratulations ryan! You’re the winner. Please follow up with me at jpo645 (@) gmail (.com) to claim your prize!

      • Hi, Jordan. I just wanted to follow up with you here to see if you had received my email. I haven’t seen a response yet, but I wasn’t sure if it was an issue on my end where the email never sent properly. Thanks!

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free 24 Excel Tips Guide

    Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'

    A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!