formatting with more than 3 colorsSolved/Closed

Question

Hello,

I need your help guys, i wanted to apply the formatting with more than 3 colors in my worksheet. 

The worksheet im working on has a lot of "tabs" , how would i make the formatting be applied in all those tabs.

What happen is the code that i have only works for the active worksheet, when i go to the next tab - nothing is 

happening. Please help!

rizvisa1 · Answer

I am not too sure what you want. It seems that you are trying to format one sheet and you want same format to be applied to same rows/cells/columns on other sheet. If that is the case first you have to select all the sheets on which you want to apply the same formatting. this you do by pressing control key and clicking on the sheets that you want. Once sheets are selected, just apply the format and it will pass thru to others

rubster · Answer

Hello rizvisa1,

I tried it and it works.. thanks a lot

Formatting with more than 3 colors

2 responses

Subscribe To Our Newsletter!