View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lee lee is offline
external usenet poster
 
Posts: 184
Default Automatically put AutoShape in certain spots

I am trying to automatically put an autoshape (circle) around certain words
when it applys. For example, I am making a worksheet for employees absences.
When they put a "1" in a cell, I want it to automatically circle the reason
they were absent. If it is a "2" then it will circle a different reason. Is
there any way I can do that? Thanks!