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.
Bookmarks