View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tphiles@aol.com is offline
external usenet poster
 
Posts: 3
Default active cell shading

I have a worksheet that keeps the active cell shaded as the cell moves down
the column. This was done awhile back, but I can't remember how it was done.
The active cell only moves down a column, not across the rows. Once data
has been entered into the cell and the enter key is hit, the next row's cell
is now active and shaded. Can anyone help me?

(A2 is active and shaded. Data is entered into A2 and the enter key hit.
A3 is now active and shaded. A2 now has no shading.)