Macro to Color Cells on Multiple Sheets

ttbuson

Board Regular
Joined
Nov 18, 2011
Messages
80
I have a workbook with some summary statistics on one sheet for a couple different sales regions. There are about seven other sheets with other data on them for the same regions. I want to keep formatting consistent across each of the sheets for each of the different regions.

I was hoping I could create a drop down list and choosing a different color in the list would apply the same text color formatting to each of the different sheets. Does anyone know a good way to go about doing this? Sorry if this question is too vague, please let me know if I should be more specific.
 

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
11,403
Office Version
2013
Platform
Windows
I have a workbook with some summary statistics on one sheet for a couple different sales regions. There are about seven other sheets with other data on them for the same regions. I want to keep formatting consistent across each of the sheets for each of the different regions.

I was hoping I could create a drop down list and choosing a different color in the list would apply the same text color formatting to each of the different sheets. Does anyone know a good way to go about doing this? Sorry if this question is too vague, please let me know if I should be more specific.
Have you looked at the Excel Conditional Format feature? In xl2007 it is on the Home ribbon menu about midway across. You can set the condition for a cell or a group of cells by selecting them and then putting the criteria in the dialogue box and the expected results. Very user friendly.
 

ttbuson

Board Regular
Joined
Nov 18, 2011
Messages
80
Yes, I know what conditional formatting is. My issue is I have multiple graphs where the data labels should match the same formatting as on the summary statistics. As far as I know, conditional formatting can't be linked from one cell to a data label.
 

Forum statistics

Threads
1,084,878
Messages
5,380,415
Members
401,673
Latest member
Ali Balleya

Some videos you may like

This Week's Hot Topics

Top