Tab color change

  • Thread starter Thread starter Thiago
  • Start date Start date
T

Thiago

I have a tab which is named "BALANCE", on this worksheet I have the balance
on cell A3. If the cell A3 is less or equal to 0 it will show red and if is
greater than 0 it will show green.
Now i want that the same color that is on A3 to be in the TAB is there a way
to automatically change the tab color as you input the number and A3 changes.
 
Assuming that the value in A3 is calculated, enter this worksheet event macro
in the worksheet code area:

Private Sub Worksheet_Calculate()
If Range("A3").Value <= 0 Then
Sheets("BALANCE").Tab.ColorIndex = 3
Else
Sheets("BALANCE").Tab.ColorIndex = -4142
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Color of cell 3
Can RGB fill color be automated based on 3 cell values? 2
Conditional Formatting Issue 3
Multiple Tab Counts 10
Excel Excel Macro help please 4
I need a formula for if cells a1 and a2 are the same then cell a3 3
Excel =SUM(A1=A1+B1) 0
If then statement 2

Back
Top