conditional formatting

Dueling: Up/Down Symbols – 1035 – Learn Excel from MrExcel Podcast

               

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. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday(…)

MrExcel’s Learn Excel #1007 – Formula Conditional Formatting

               

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. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video(…)

MrExcel’s Learn Excel #938 – Excel Is Fun

               

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. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a(…)

MrExcel’s Learn Excel #933 WIIW – Conditional Formula

               

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. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Episode 901 – Highlight Weekends

               

Morne sends in a question about highlighting records that fall on a weekday. There are a couple of approaches. Episode 901 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(…)

Learn Excel from MrExcel