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

We’ll tackle that next. How to count the color codes As is, the matrix returns the fill color codes for each cell in the data set. Using COUNTIF (), we can easily count the blue cells in each row.

1. Highlight all the rows with sales from 100 to 500 million. To choose a background color, click Home on the main menu row and go to the Font group.