ExcelBanter - How do I do fomrmating based on Outline?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I do fomrmating based on Outline? (https://www.excelbanter.com/excel-discussion-misc-queries/95419-how-do-i-do-fomrmating-based-outline.html)

Vinaya

How do I do fomrmating based on Outline?

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

Vinaya

How do I do fomrmating based on Outline?

No way?
"Vinaya" wrote:

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

Dave Peterson

How do I do fomrmating based on Outline?

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

Apply the format you want.

repeat as necessary.

Vinaya wrote:

No way?
"Vinaya" wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 09:18 AM.