Odd or even row color easy way.

Some time need to odd row or even row color in ms excel sheet for easy way working.But manually this work is very difficult and time killing .Easy way solve this thing, at first sheet select than go to menu bar click

format menu than click conditional formatting select formula is and add formula =ODD(ROW())=ROW() or =Even(ROW())=ROW()and color select and out click by OK. Enjoy

Download the workbook. 

Tweet