conditional formatting

Make Font Red If It Meets a Condition – Without Conditional Formatting

               

Before there was conditional formatting, there was custom number formatting. You can still add a condition to your custom number formats. Select the range of cells. Press Ctrl+1 to open the Format Cells dialog. Select the Number tab. Choose Custom from the bottom of the list. In the Type box, enter a format such as(…)

Dueling Excel – “When Project Finished, Mark All Green”: – Podcast #1877

               

Today in Duel 157, Mike and Bill look at completed project records. If any record for the project is marked Back

Learn Excel – “VBA Happy Holidays by Jordan Goldmeier”: Podcast #1842

               

Excel MVP Jordan Goldmeier created an Excel-based Happy Holidays card complete with …This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!“The Learn(…)

Learn Excel from MrExcel – “Dots”: Podcast #1739

               

Do You play ‘Dots’ on iPad?

Dueling Excel – “Highlight Open Items after 4 Days”: Podcast #1717

               

Dueling Excel looks at Conditions and Causes – And NO VBA!

Learn Excel from MrExcel