Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coloring a range depending on a cell value
Hi everybody. I have created the follwoing code to color a specific range when th value of cell A1 =1 and uncolor it when it is more than 1. The problem I faced is that when the code is applied the whole shee becomes un-editable except cell A1, which contains the value. what I want is to make the whole sheet active and editable afte applying the follwoing code. Code ------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value = 1 And Target.Address < "$A$1" Then Range("B2:F2").Select With Selection.Interior .ColorIndex = 6 End With ElseIf Range("A1").Value 1 And Target.Address < "$A$1" Then Range("B2:F2").Select With Selection.Interior .ColorIndex = 0 End With End If End Su ------------------- Thank you for all -- Jim33 ----------------------------------------------------------------------- Jim333's Profile: http://www.excelforum.com/member.php...nfo&userid=518 View this thread: http://www.excelforum.com/showthread.php?threadid=47330 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coloring a range depending on a cell value
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value = 1 And Target.Address < "$A$1" Then Range("B2:F2").Interior.ColorIndex = 6 ElseIf Range("A1").Value 1 And Target.Address < "$A$1" Then Range("B2:F2").Interior.ColorIndex = xlNone End If End Sub -- Regards, Tom Ogilvy "Jim333" wrote in message ... Hi everybody. I have created the follwoing code to color a specific range when the value of cell A1 =1 and uncolor it when it is more than 1. The problem I faced is that when the code is applied the whole sheet becomes un-editable except cell A1, which contains the value. what I want is to make the whole sheet active and editable after applying the follwoing code. Code: -------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value = 1 And Target.Address < "$A$1" Then Range("B2:F2").Select With Selection.Interior .ColorIndex = 6 End With ElseIf Range("A1").Value 1 And Target.Address < "$A$1" Then Range("B2:F2").Select With Selection.Interior .ColorIndex = 0 End With End If End Sub -------------------- Thank you for all. -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=473303 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coloring a range depending on a cell value
Thank you sooooooooo much Tom That is exactly what I want .. Thanks alot. Bye, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=473303 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell coloring when the value is an integer and within said range | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Conditional formatting depending a range of cell | Excel Worksheet Functions | |||
Coloring a range depending on a cell value | Excel Programming | |||
print a certain range depending what is in cell? | Excel Programming |