Oz du Soleil experiments with how to visualize music in Excel.  To do this, he takes the song “Pressman” by Primus.  Oz is a bit of a bass player, so his choice of Primus is…  well… not entirely unexpected.

Shocker.

But what is a bit surprising… or novel… is how he uses Excel in a way that most people would not consider.  Turning on and off different accompaniments, so that he can visualize the instruments that are being played at different parts of the song.  Its an interesting approach that is worth exploring

## Go to the Developer Tab

If you don’t see the developer tab, then go to

Preferences>Sharing and Compatibility>Ribbon

select “Developer”

Please note tat your particular version of Excel may reveal the developer tab in different ways.

In the video Oz shows you how he the radio buttons to place a number (such as 1, 2, 3, 4, 5) based on which radio button is selected.  In Oz’s example, he places the value in cell T12

## Use and Index Formula for the Lookup

Use and Index formula to grab the value from Step #2 to perform a lookup.

## Apply Conditional Formatting

The conditional formatting formula that is used looks at cell T14 — which is where the calculation from Step #3 was performed, and looks to see if that value is found anywhere in the the measures (columns ‘E’ through ‘M’).

Tags

#### You may also like

December 20, 2013

## 100+ Best Excel Resources And Websites

100+ Best Excel Resources And Websites

August 6, 2019

## How to Create a Relative File Path in Power Query

How to Create a Relative File Path in Power Query

December 20, 2013

## 100+ Best Excel Books – Learning Spreadsheets

100+ Best Excel Books – Learning Spreadsheets

April 9, 2011

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

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

September 17, 2012

## The Excel Rollover Mini FAQ

The Excel Rollover Mini FAQ

February 17, 2014

## It’s time to say “Goodbye,” to Hungarian Notation

It’s time to say “Goodbye,” to Hungarian Notation
• Rick Grantham,
Thanks for the post. This is a very nice way. I enjoyed it really and mentioned this technique in my blog post.
http://goo.gl/zHfjxI
Thanks again to Oz du Soleil for this nice tricks.
Regards
Kawser Ahmed
Data Lover