Thread
:
Change cell font color when cell is clicked
View Single Post
#
4
Posted to microsoft.public.excel.programming
aileen
external usenet poster
Posts: 78
Change cell font color when cell is clicked
Don,
I was able to get the cell color change to work, but I'm still working on
having a formula in another cell in the same row change based on the cell I
choose to color.
Any ideas?
Thanks,
Aileen
"Don Guillett" wrote:
Nothing wrong with what you present.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"aileen" wrote in message
...
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.
.
Reply With Quote
aileen
View Public Profile
Find all posts by aileen