S
S Himmelrich
I'm trying to change the background color of a cell based on a value,
however instead of using the syntax below can you refer to a cell with
a value instead of hardcoding the value in the macro? If you can,
then what is the syntax? thank you in advance
Select Case Range("A1").Value
Case 100
Range("B1").Value = 50
Case 150
Range("B1").Value = 40
Case 200
Range("B1").Value = 30
Case 350
Range("B1").Value = 20
Case 400
Range("B1").Value = 10
Case Else
Range("B1").Value = 0
however instead of using the syntax below can you refer to a cell with
a value instead of hardcoding the value in the macro? If you can,
then what is the syntax? thank you in advance
Select Case Range("A1").Value
Case 100
Range("B1").Value = 50
Case 150
Range("B1").Value = 40
Case 200
Range("B1").Value = 30
Case 350
Range("B1").Value = 20
Case 400
Range("B1").Value = 10
Case Else
Range("B1").Value = 0