Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab Color Changes depending on value of a cell
Is there a way to automatically change the tab color depending on the value
of a cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab Color Changes depending on value of a cell
You gave NO detail but this will change tab color to number entered in cell
d1. Right click sheet tabview codeinsert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$D$1" Then Exit Sub Me.Tab.ColorIndex = Target End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Thiago" wrote in message ... Is there a way to automatically change the tab color depending on the value of a cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Cell Background Color Depending on the Number | Excel Discussion (Misc queries) | |||
add up a list of values depending on the color of the cell | Excel Discussion (Misc queries) | |||
Different background color depending on x-axis value | Charts and Charting in Excel | |||
Cell color depending on statement | Excel Discussion (Misc queries) | |||
Changing cell or text color depending on week number | Excel Discussion (Misc queries) |