Thank you for your support
Please Subscribe

If you want to apply color in alternate rows and columns in an Excel spreadsheet, here is what you need to do. It is possible to show the desired color in every alternate row or column with the Conditional Formatting. This functionality is included in Microsoft Excel, and you can make use of it with the help of this tutorial.

Please follow the following Steps

1.Open the spreadsheet with Excel.
2.Select the rows and columns that you want to colorize.
3.Click the Conditional Formatting in the Home tab.
4.Select New Rule from the list.
5.Select Use a formula to determine which cells to format.
6.Enter =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0 in the Format values box.
7.Click the Format button.
8.Switch to the Fill tab.
9.Select a color that you want to use.
10.Click the OK button twice.

Disclaimer
This video is intended for educational purposes only, I am not responsible for anything you do with the information provided below.
I do not have any affiliation with any of the businesses, apps, or websites mentioned in this video. This video and all videos on (Lewis Geek World channel) are for informational purposes, I report information that is freely available elsewhere and available to everyone for FREE. I do not condone piracy of any nature. I do not host or upload any video, media files, servers, ect… We are not responsible for the copyright, compliance, decency or legality or anything else streamed from your device. If you have any legal questions please contact the media file holder or host site. These videos are for informational purposes ONLY. I’m not responsible for the content streamed to your device.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.