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.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.