• Why Haven’t You Adopted Power Pivot Yet?

                   

    It is late 2014, almost 4 years after PowerPivot reached general availability. This product is a game-changer. It enables people to do dramatically more powerful analyses than regular pivot tables. Yet, when I walk into a room full of 100 people who opted to come to a Power Excel with MrExcel seminar, there are only(…)

    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(…)

     

The MrExcel Archive

Learn Excel from MrExcel