How do I do fomrmating based on Outline?

V

Vinaya

Hi,
I want format Exel based on outline.
I have sheet with outline, I want to apply different format to different
layer. How do i do it?
Thanks in advance
 
D

Dave Peterson

Hide/show what you want.
Select the area
Edit|goto|special
select visible cells only

Apply the format you want.

repeat as necessary.
 
Top