Thread
:
Change Cell Color when another cell is selected
View Single Post
#
1
Posted to microsoft.public.excel.misc
JB
Posts: n/a
Change Cell Color when another cell is selected
http://cjoint.com/?fDvhRg4sDJ
-Select A2:D16
-Format/Conditiannal formatting
=Row()=Cell("row")
=Column()=Cell("Column")
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Calculate
End Sub
Cordially JB
Reply With Quote