Learn Excel from Bill Jelen with this daily 2 minute video podcast.
In Episode 1150, I wanted to add data bars to a series of words. Episode 1150 shows you how.
Labels: conditional formatting, data bar, format, VBA
posted by Bill at 9:00 AM
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.
Labels: conditional formatting
posted by Bill at 9:00 AM
Jonathan asks how to insert an Up/Down arrow as the result of an IF statement. In Dueling Excel Episode 1035, Bill and Mike show you a few ways how to do this.
Labels: conditional formatting
posted by Bill at 9:00 AM
William asks how to base his conditional formats on a start date in column A and a duration in column B. This calls for the Formula version of conditional formatting. Episode 1007 shows you how.
Labels: conditional formatting, format
posted by Bill at 9:00 AM
If you like my videos, check out the YouTube channel EXCELISFUN. Mike Gel Girvin has an amazing collection of enthusiastic Excel Videos on YouTube. Also in Episode 938 - an improvement for episode 933: =MOD(ROW(),2) is equivalent to =MOD(ROW(A2),2)=1.
Labels: conditional formatting, ExcelIsFun, Formatting
posted by Bill at 9:00 AM
Excel 2003 used to offer an obscure conditional formatting option called Formula Is. It is still obscure in Excel 2007. Episode 933 will show you the ROW, MOD functions and a dynamic solution to formatting every other row.
Labels: conditional formatting, Formatting
posted by Bill at 9:00 AM
Morne sends in a question about highlighting records that fall on a weekday. There are a couple of approaches. Episode 901 shows you how.
Labels: conditional formatting
posted by Bill at 9:00 AM
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.
Labels: conditional formatting, Formatting, Pivot Table
posted by Bill at 9:00 AM
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.
Labels: conditional formatting, Grouping, Pivot Table
posted by Bill at 9:00 AM
Matthew from Washington wants to take an event database and create a visual calendar that shows availability.
Labels: Calendar, conditional formatting, Named Ranges
posted by Bill at 9:00 AM
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.
Labels: conditional formatting, formula is, practice tests
posted by Bill at 9:00 AM
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.
Labels: conditional formatting, dates, formula, TODAY
posted by Bill at 9:00 AM
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 make it work.
Labels: conditional formatting, Find, ISERROR
posted by Bill at 9:00 AM
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.
Labels: conditional formatting, Greenbar
posted by Bill at 9:00 AM
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.
Labels: chart, color, conditional formatting
posted by Bill at 9:00 AM
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 formatting option to allow this to happen.
Labels: conditional formatting
posted by Bill at 9:00 AM
