{"id":12118,"date":"2012-01-14T20:35:17","date_gmt":"2012-01-14T20:35:17","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1217"},"modified":"2012-01-14T20:35:17","modified_gmt":"2012-01-14T20:35:17","slug":"shade-alternate-rows-using-conditional-formatting","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/01\/shade-alternate-rows-using-conditional-formatting\/","title":{"rendered":"Format Alternate Rows using Conditional Formatting"},"content":{"rendered":"
Dear Readers,<\/p>\n
In this article I am going to explain you, how you can format the Alternate Rows of Excel using Conditional Formatting.<\/a> For example, in Excel Sheet, if you want alternate rows to be shaded in different color. This you usually need when you are preparing some report and want your report looking very nice. Step 1.<\/strong>Select the Area which you want to be shaded. If you want the whole Sheet to be formatted then Select the whole sheet.
\nFollow the below Steps to do so:<\/p>\nSteps to Shade Alternate Rows (Automatically)<\/h3>\n
\nStep 2.<\/strong> Go to the Home Tab in the Menu Ribbon (Excel 2007) –> Click on Conditional Formatting Option
\nSte 3.<\/strong> Click on Add New Rule
\nSte 4.<\/strong> Select the Format Type as “Use a Formula to Determine Which cells to format”<\/p>\n