autoformat add or change

  • Thread starter Thread starter bwilde
  • Start date Start date
B

bwilde

Can you add a new auto format and/or change one. There is an autoformat
list1 that hilites every other row in light grey is there a way to make it a
different color?
list 2 is green, but it hilites every two rows.
 
Roll your own using Conditional Formatting

Select a bunch of rows.....not cells, rows.

Format>Conditional Formatting>Formula is:

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Format to your choice of color and hit OK


Gord Dibben MS Excel MVP
 
Back
Top