Hello everybody. We had a two answers submitted by our friends Don and Pete. Surprisingly, they had the same thought.
They both thought that the best solution is not an Excel Chart. But instead, they thought the best solution was to use Excel Conditional Formatting. Sometimes the answer is NOT a chart or graph. It is always a good thing to remember when working on your own solutions.
You can download their solution files below. To check out their Conditional Formatting formulas, go to your Home ribbon and then click on the Conditional Formatting button and then choose the “Manage Rules…” menu item:
If you don’t understand how to apply Conditional Formatting to your Excel Spreadsheet cells, check out this post:
Here is another example of Excel Conditional Formatting in action:
Don gets the extra credit point for creating 2 different Conditional Formatting options with some included instructions.
You should check out both of their answers in the files above. Thanks guys, you rock!!!
Now, here is where I differ from my esteemed Excel All-Stars of Pete and Don. My answer is a completely different take on this challenge.
Stay tuned for the next post!