| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Case and referencing a cell instead of a value
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change data of entire column from small case to upper case | Excel Worksheet Functions | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Threaded Mode
