At times when you’re staring at an Excel spreadsheet for a while it is nice to have certain rows stand out based on certain conditions. A little Excel feature I use every now and then is the conditional formatting found in menu item Format > Conditional Formatting…

If you would just like to highlight a cell, use the “Cell value is” condition and edit the formatting background. If you would like to highlight the entire row, use the “Formula is” condition with the =INDIRECT() function.

For example, if you would like to highlight all rows where cell C of a row has a value less than 0, use =INDIRECT(“C”&ROW())<0

See screenshots:


[Original Source]