How can you quickly highlight with color the rows in subtotals in Excel?
S Steven Forbes, Verizon Corporation Jul 12, 2005 #1 How can you quickly highlight with color the rows in subtotals in Excel?
D Dave Peterson Jul 12, 2005 #2 Use the outlining symbols to show just the subtotals. Then select that range. edit|goto|special|visible cells only format the visible cells the way you want.
Use the outlining symbols to show just the subtotals. Then select that range. edit|goto|special|visible cells only format the visible cells the way you want.