Excel 2007 : Change the tab color based on value in a cell? Is it possible?

[tanda]

I use conditional formating in my workbooks and was wondering if there is a way to use the same concept to change the color of a tab based on the value in a cell.

Thanks!

[jeffreybrown]

You won't be able to do this with conditional formatting, but a little VBA routine will work.

Are you interested in using VBA?

If so, when the user changes the value in cell A1 and it equals 2, then the tab is colored red.

Please Login or Register  to view this content.

This is worksheet code >> right click on sheet tab >> View Code >> Paste on right side of screen

[tanda]

Thanks Jeff, it worked great!

[jeffreybrown]

You're very welcome tanda...glad you got it all sorted out and thanks for the feedback