LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format adds 2 spots in front of number David Excel Discussion (Misc queries) 2 February 20th 07 07:45 PM
NAME OF AUTOSHAPE Ronbo Excel Discussion (Misc queries) 3 August 18th 05 10:09 PM
black background with white spots in the texture steve Excel Discussion (Misc queries) 0 August 6th 05 01:36 AM
what are the blue spots that appear and disappear? Jonathan P Excel Discussion (Misc queries) 3 July 27th 05 08:16 AM
I need to add mew rows for different spots. Confused1 Excel Discussion (Misc queries) 0 June 28th 05 11:26 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"