Let’s say you want to highlight every second month (i.e., February, April and so on) in this data set. Suppose you have a dataset as shown below: Watch Video – How to Highlight Alternate (Every Other Row) in Excelīelow is the complete written tutorial, in case you prefer reading over watching a video.Ĭonditional Formatting in Excel can be a great ally in while working with spreadsheets.Ī trick as simple as the one to highlight every other row in Excel could immensely increase the readability of your data set.
