Changing the colour of a tab based on a cell value

**lauz125** · 05-29-2013, 08:05 AM

Hi,

Does anyone have the code I need to use in order to change the colour of a worksheet tab based on a cell value? There are probably about 50 worksheets, and if the value in cell A2 is 0 I would like it to change colour. If it is not zero I would like it to stay as it is, with no colour on the tab. The value in cell A2 will be formula driven.

Thanks in advance

**dilipandey** · 05-29-2013, 08:18 AM

Hi Lauz125,

welcome to the forum.

Try below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

**lauz125** · 05-29-2013, 08:27 AM

Hi,

Thanks for the reply. It doesn't seem to be making the tabs change colour. Should this work as I'm wondering if I have done something wrong?

**dilipandey** · 05-30-2013, 04:15 AM

Okay.. can you upload your workbook where you performed this testing ? Thanks.

Regards,
DILIPandey
<click on below * if this helps>

Changing the colour of a tab based on a cell value

LinkBack

Thread Tools

Rate This Thread

Display

Changing the colour of a tab based on a cell value

Re: Changing the colour of a tab based on a cell value

Re: Changing the colour of a tab based on a cell value

Re: Changing the colour of a tab based on a cell value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions