A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
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!
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 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!
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!
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide