Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell font color when cell is clicked
I'm trying to find code that will change the font color or interior color in
a cell when the cell is clicked once. Then when the color changes I need to recalculate a formula from a different cell in the same row based on which cell was chosen and had the color change. I was trying the following code as a start but I am getting an "End If without a Block If" error. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("L2:M500")) Is Nothing Then Target.Interior.ColorIndex = 5 End If End Sub Any help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
Reg. Change of font color in a cell | Excel Worksheet Functions | |||
Change font color in cell | Excel Discussion (Misc queries) | |||
Change Font Color in cell Based on another cell value | Excel Programming | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |