| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change cell colour
How can I make a cell change colour according to the result of its LOOKUP
formula? I have put in the following code, but this will only work on cells that don't have the formula, whereas I need the cells to change colour according to the result of the formula. Hope this makes sense! Dim color As Integer If Not Intersect(Target, Range("c1:c10")) Is Nothing Then Select Case Target Case 3 To 17 color = 3 Case 19 color = 45 Case 21 color = 4 Case 23 To 35 color = 33 Case Else 'Whatever End Select Target.Interior.ColorIndex = color End If |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change cell colour
Worksheet_Change does NOT fire if the change is result of a formula
calculation. "Min" wrote: How can I make a cell change colour according to the result of its LOOKUP formula? I have put in the following code, but this will only work on cells that don't have the formula, whereas I need the cells to change colour according to the result of the formula. Hope this makes sense! Dim color As Integer If Not Intersect(Target, Range("c1:c10")) Is Nothing Then Select Case Target Case 3 To 17 color = 3 Case 19 color = 45 Case 21 color = 4 Case 23 To 35 color = 33 Case Else 'Whatever End Select Target.Interior.ColorIndex = color End If |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change colour of cell if there is no value | Excel Worksheet Functions | |||
| change row colour when a value is given in a cell | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Change cell colour | Excel Worksheet Functions | |||
| COLOUR CHANGE IS A CELL | Excel Discussion (Misc queries) | |||
Linear Mode
