{"id":12089,"date":"2011-11-19T12:15:09","date_gmt":"2011-11-19T12:15:09","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=670"},"modified":"2011-11-19T12:15:09","modified_gmt":"2011-11-19T12:15:09","slug":"conditional-formatting-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/conditional-formatting-in-excel\/","title":{"rendered":"Conditional Formatting in Excel"},"content":{"rendered":"
In MS Excel we can do formatting of cells based on some conditions or values. This is called Conditional formatting. For example, if you want a cell color to be red whenever the Value in the Cell is updated as “FAILED” or “Less Than 60%” etc. then we can apply conditional formatting in that cell.
\nConditional formatting can be done on a single cell or a range of cells or in complete row or column.<\/p>\n
Following are the steps to do Conditional Formatting in Excel 2007:<\/p>\n
Step 1. First of All Select the Cell or Cell Range<\/strong> where you want to apply this conditional formatting<\/p>\n Step 2. Go to Home Tab –> Conditional Formatting –> New Rule<\/strong><\/p>\n