Change tab color based on formula

[Sammi8796]

I wanted to know if you can change the color of a tab based on the contents of a cell by using a formula? The contents of the cell are returned from a basic formula. The number would either be a positive number or a negative number. I wanted the tab to turn red if the cell returned a negative number or stay the same if it returned anything over "0."
Example: cell O32 contents are 372, therefore the tab stays the same. Cell O32 contents are -23, therefore I want the tab to turn red. Any help would be appreciated. Thanks!

 

[JackDanIce]

Put this code into your worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value < 0 Then
    ActiveSheet.Tab.ColorIndex = 3
Else
    ActiveSheet.Tab.ColorIndex = 2
End If
End Sub

 

[Sammi8796]

Forgive me, I'm not at all familiar with code...where am I putting this? And would I need to insert this into each tab? Thanks again.

 

[Sammi8796]

I think I found the window that I should enter it in VBA. I did that but I'm not seeing any results. Anything that you can point me in the right direction would be appreciated.