Office expert Susan Harkins teaches you two ways to highlight the lowest and highest values in an Excel row or column.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

The example tells Excel to look in column "B" for each row and determine if the values are less than zero. If a value is less than zero, the conditional formatting is applied to that row.

This pastes that cell's value the rest of the cells in the column, until the highest row number in the worksheet.