View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rhonda Rhonda is offline
external usenet poster
 
Posts: 64
Default How do I have a cell highlight when selected?

Is there a way to click on any cell either with tab or arrow key and that
cell automatically highlights in a color such as red? This is requested so
that if a person is working in a long spreadsheet with alot of statistics,
they will be able to see the cell that they have selected as it will be
highlights. I tried to create a macro but could not figure out how to make
it automatically highlight a cell when selected throughout the spreadsheet.
Any help or suggestions will be greatly appreciated? Any other solutions
will be greatly appreciated!