View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
charles charles is offline
external usenet poster
 
Posts: 124
Default Highlight the cells referenced in the active cell formula

I want to have the cells that are referenced in the active cells formula
highlight. For example if I have column A cell 1 with a formula of
=sum(b2+c3+g6) I would like for the cells b2, c3, g6 to highlight yellow. The
formula changes for each cell as do the referenced cells. Does anyone know if
this is possible?