Sometimes we need automatic colorisation of the rows based on the value of a cell. Its not only save lot of time as well as simplify identification of records based on the colors. Thanks to excel conditional formating that allow you to do. Formatting cell based on the condition is easy but formating entire row or column is little tricky.
To Do ->
Select the area you want to cover for formatting. You can select entire workbook if you want to cover complete all cell and columns.
Go to Format Menu -> Conditional Formatting
See the above figure, you will notice INDIRECT function. The INDIRECT function used to create cell or range reference while formula evaluated. The function allows you to put the address of another cell within a cell, and get data from the the other cell by referencing the first cell.? ?
The condition check column C in each selected row and change formatting according to specification.