| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q: How to change tab color based on cell value
Using VBA and Excel 2002, how can I change a tab color whenever any
cell on that tab/sheet has its interior color becomes equal to index 4 (green)? What I'm trying to accomplish: Cells on a sheet contain conditional formatting that when given a certain condition will change the interior color of that cell to green. This workbook contains many sheets...so to make it quicker to find those green cells, the related tab will also change to green. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Can a cell change color based on the value of another? | Excel Discussion (Misc queries) | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Change tab color based on a cell value | Excel Discussion (Misc queries) | |||
![John[_60_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
