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

    Data Pasted to Excel Starts Splitting at Comma?

                   

              Usually, you grab text from Notepad or Email or a web page, paste to Excel, and it all stays in one column. But…one day, late in the afternoon, the pasted data starts automatically parsing into separate columns!     Here is the deal… I bet you did a Text to(…)

     

The MrExcel Archive

Learn Excel from MrExcel