Tab color change based on cell content

Hi,
I have no knowledge of VBA so any help you give me would need to be very specific. I'm using excel 2003. I would appreciate any ideas you may have.
I have a workbook that I would like to change the tab color of each sheet based on the results of cell O32 of each sheet. Each tab is exactly the same, just the data is different. O32 has a simple formula in it. I'd like the tab to change to red if the result is a negative number. So, to sum it up, I'd like the tab color to change to red for each sheet based on the cell result of O32 in each individual sheet. Can someone provide me with code for this and explain exactly how/where to enter? O32 is a merged cell, will this be an issue? Thanks in advance for any help.

Welcome to the forum!

In VBE, Insert, Module, and paste:

Please Login or Register  to view this content.

Hi, Thanks for the reply. I copied the code and tried it and it didn't work. I'm sure I'm doing something wrong...can you be a little more specific. When I open VBA the two drop downs say: The Middle left says General and the one on the right says NegRed. Is this correct? My macros are enabled. Thanks,

Yes, what you have explained is what I did. It isn't changing any tabs red. Do you have any other ideas as to why it may not be working?

By the way, after I entered the code and have saved and closed the workbook, when I reopen the workbood and I hit Alt + F11 to view code, a blank VBA form comes up. I have to go to the left side window and click the module folder, then module 1 for the code to populate. Is this correct? Shouldn't it show me the code when I "view code?"

Originally Posted by sammi8796

By the way, after I entered the code and have saved and closed the workbook, when I reopen the workbood and I hit Alt + F11 to view code, a blank VBA form comes up. I have to go to the left side window and click the module folder, then module 1 for the code to populate. Is this correct? Shouldn't it show me the code when I "view code?"

Double clicking on the module should show the code. I suspect the code isn't in the module. Try the above instructions again to create the code.

Alternatively, try clicking on the Developer Tab, in the Developer Area, click on Macros. A dropdown list of available macros should appear, double click on NegRed (assuming it is there).

The code is in the module folder under module1. When I double click it, it is there. I was just saying that when I hit alt + F11 it doesn't show the code unless I go to it by double clicking module 1. I thought that is odd. Where is the developer tab? Thanks,