conditional formatting

Episode 517 – Conditional Find


Rod calls in a question today; how to use conditional formatting to highlight all the track athletes from a particular school. This requires the conditional format to look for the school name within a cell. This is very easy in Excel 2007 but very difficult in Excel 2003. Episode 517 discusses the functions required to(…)

Episode 470 – Conditional Formatting


Today’s guest podcaster is MVP Zack Barresse. Zack shows how to apply a greenbar formatting using a cool conditional formatting formula. Episode 470 shows you how.

Episode 427 – Gantt Chart


This cool trick shows you how to create a Gantt chart right in the Excel cells by using Conditional Formatting. The chart is a live chart that colors cells based on several data values. Episode 427 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a(…)

Episode 347 – Andy’s Problem


Andy “Cyber” Walker once asked me what seemed like a simple question – he wanted to use conditional formatting to change records to green if the total of all records for that day exceeded $1000. While this sounds simple, it actually is incredibly complex to set up. Episode 347 walks you through the amazing conditional(…)

Learn Excel from MrExcel