View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saucer Man Saucer Man is offline
external usenet poster
 
Posts: 54
Default Conditional Formatting help please

I would like to accomplish two things.

1) In the last cell of a row, I only want the cell to accept a numeric 0-9
with 3 places. So, 019 would be valid. If the user types anything else,
nothing would appear.

2) When the user hits TAB or Enter in the last cell of a row, the cursor and
screen reposition to the first cell of the next row.

Thanks!


--- Posted via news://freenews.netfront.net/ - Complaints to ---