Posted on January 25th, 2011 in Random | No Comments »
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