Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do we have any option to declare active and inactive background colors to the entire sheet at once?

Hi, Vinay Bangari

If i have 10 tables and i want to declare active and inactive background colors, do i have to do it separately for all the 10 table? or is there a way to declare the color to the entire sheet objects or something like that?

Thanks,

Akshay

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I assume by Active/Inactive colors you mean Caption colors.

1. Change one object to the colors you want.

2. On the Layout tab for that object, press the "Apply To" button.

3. The next menu will provide some filters that controls which other objects to copy the Caption and Border properties to.

-Rob

http://masterssummit.com

http://robwunderlich.com

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I assume by Active/Inactive colors you mean Caption colors.

1. Change one object to the colors you want.

2. On the Layout tab for that object, press the "Apply To" button.

3. The next menu will provide some filters that controls which other objects to copy the Caption and Border properties to.

-Rob

http://masterssummit.com

http://robwunderlich.com

Not applicable
Author

Wow!! That worked, I don't have to do it for each object now. Thank you Rob.


-Akshay