User Tools

Site Tools


microsoft_excel:alternative_row_colors

This is an old revision of the document!


Microsoft Excel - Alternative Row Colors

Select the entire column with the group numbers.

  • Select the data range
  • In the Home ribbon select Conditional Formatting → New Rule.
  • Choose Use a formula to determine which cells to format.
  • In the formula cell, put =MOD($A1, 2)=1 as the formula.
  • Click Format, select the Fill tab.
  • Select the Background Color you want, then click OK.
  • Click OK.
microsoft_excel/alternative_row_colors.1605475534.txt.gz · Last modified: 2020/11/15 21:25 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki