Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color change
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color change
See ans in your previous post about an hour ago
-- Don Guillett Microsoft MVP Excel SalesAid Software "Thiago" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab color change
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 -- Gary''s Student - gsnu200803 "Thiago" wrote: 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. |
Reply |
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) | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) |