View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelguy[_2_] excelguy[_2_] is offline
external usenet poster
 
Posts: 27
Default conditional formatting

i want to color/shade row a2:c2, a30:c30 and every 28 rows after a30:c30 in
green. i think i have to use the conditional formatting but what should i
type in so I dont have to highlight thousands of rows manually.