How To Calculate RGB Colors In Excel? - Excel Challenges - Excel TV
Excel TV
Share The LOVE

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 www.myonlinetraininghub.com. 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 www.thespreadsheetguru.com. 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!

  • Ryan Tretter says:

    Red + (Green*256) + (Blue*256*256) or 130 + (210*256) + (11*256*256) = 774,786.

    • Jordan Goldmeier says:

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

      • Ryan Tretter says:

        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!

  • >