Why don't you use conditional formatting instead, it would save you a lot of
work. Select the range to apply the formatting to and click FORMAT in the
menu, select CONDITIONAL FORMATTING, change the cell is to FORMULA IS and
enter the following formula, changing the A1 to the first cell in your
selected range.:

A1=1

Click the FORMAT button and then click the PATTERNS tab and assign a color
to the cell. User condition 2 for the second value.
--
Kevin Backmann


"Lee" wrote:

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!