I want to insert a line shape and have the color and weight of that line be controlled by a value of a cell
for example of cell A1 is =1 then the line would be green and fat
if i change the value of Cell A1 to =2 then the line would turn to black and shinny
any way to do this?
You might need VBA for that. Insert the code to Worksheet module and you might need to play around with the set or shape design.
Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1") = 1 Then Shapes("Oval 1").ShapeStyle = msoShapeStylePreset14 If Range("A1") = 2 Then Shapes("Oval 1").ShapeStyle = msoShapeStylePreset13 End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks