Conditional Tab Color

[hedgie]

Actually a two part question. One sheet in a workbook is a testing sheet to see if certain conditions are met. I would like to have the Tab color turn Red if any of the Conditions are present. Currently the sheet has conditional formating for each condition and sets the color to yellow within the cell that is meeting that particular condition. 1) is there a way to populate a test cell that will put a "1" in place if any of the other cells are yellow. 2) if that test cell has a 1, have the tab color change to red?

 

[erik.van.geit]

Hi,

1. CELL = 1
you will need to use the formulas from conditional format
this is the only way to "see" if the cells are yellow
2. TABcolor

Private Sub Worksheet_Calculate()
Me.Tab.ColorIndex = IIf(Range("A1") = 1, 3, -4142)
End Sub

http://www.cpearson.com/excel/events.htm
TO INSTALL IN SHEET CODE WINDOW:
1. right click the "Name Tab" of sheet you want code to work in
2. Select "View Code" in drop down menu
3. VBE window will open ... paste code in and exit VBE
kind regards,
Erik