conditional formatting

Episode 875 – Conditional Pivot Formatting

               

Neville from Germany sends in a good suggestion for overcoming pivot formatting problems from Episode 865. By using conditional formatting on the underlying worksheet, Neville comes up with a way to make sure that the total rows are always highlighted in a pivot table. Episode 875 shows you how. This blog is the video podcast(…)

Episode 723 – PivotText

               

After summarizing data in a pivot table, you want to replace the numbers with a simple Yes/No text. Yes if they met the condition, No if they did not. Episode 723 will show the rather convoluted process. In the process of creating the pivot table, you will see data grouping, calculated fields, table options, and(…)

Episode 717 – Event Calendar

               

Matthew from Washington wants to take an event database and create a visual calendar that shows availability. While this sounds simple, it requires several steps. The end result is fairly cool. Episode 717 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two(…)

Episode 682 – Quiz Practice

               

Ross is heading back to university and was hoping to use Excel to quiz himself. In Episode 682, I will show you how to use conditional formatting to hide the correct answer until an answer is filled in. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a(…)

Episode 551 – Red-Flag Dates

               

Van writes in with a suggestion about podcast 539. In that podcast, we were trying to calculate which customers had their birthday coming up soon. Van suggests using conditional formatting and the TODAY() function to flag the customers to whom you need to send birthday cards. Episode 551 shows you how. This blog is the(…)

Learn Excel from MrExcel