Name: Upendra Singh Tip: color Every Alternate Row in data with conditional Formatting (without Macro)
1. Select the data you want to Format. 2. Go to Conditional Formatting. 3. In the first box, Select “Formula is” and type the formula : =MOD(ROW()-1,1*2)+1>1. 4. Set the format and Press Ctrl+Enter. Regards, Upendra Singh 9910227325 ------------------------------------------------------------------------------------------------------------- There are 10 kinds of people: Those who understand binary and those who don’t --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
