conditional formatting

Icon Set Boundaries? Episode #1208

               

Patrick asks how Excel chooses to assign icons to values when you use the icon set feature. Episode 1208 explains how the icon sets work and how to change the default behavior. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday(…)

Highlight Largest Row – Episode #1207

               

This problem is similar to Episode 1206, but this time the question is how to highlight the entire row of the record with the largest value. Episode 1207 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn(…)

Highlight Lowest in Row – Episode #1206

               

How can you highlight the lowest value in each row? Episode 1206 shows you how. …This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book

Word DataBars – 1150 – Learn Excel from MrExcel Video Podcast

               

In Episode 1150, I wanted to add data bars to a series of words. Episode 1150 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dueling: Removing $ – 1075 – Learn Excel from MrExcel Podcast

               

Manfred from Germany has an interesting problem. Each record takes up six rows in his spreadsheet. Formulas need to point to the first row of the company. Those formulas need to be copyable. But those formulas are in conditonal formatting rules. Episode 1075 tries to solve this problem. This blog is the video podcast companion(…)

Learn Excel from MrExcel