Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

Click the drop-down arrow to the right of the Bottom Border button in the Font part of the Ribbon toolbar. Click "All Borders." A border is displayed around all borders of each cell you selected.