Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.

If you want to hide and unhide columns and rows in Microsoft Excel, then know it is easier than you might have thought. We explain how.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...