View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JB
 
Posts: n/a
Default 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