I tried that before, the problem is I have text going over several ungrouped
cells. I need something that will print on a black and white printer and
look somewhat like a circle. I tried to do a border using the conditional
formating but it just made a bunch of little boxes.

Any other suggestions???

"Kevin B" wrote:

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!