You could do it, but I wouldn't.

I would think that those pictures would cause more trouble than what they're
worth--sorting/filtering may cause a bunch of trouble.

If I really wanted something "organic", I'd stick with format|Conditional
formatting. In fact, I'd even use a separate column of formulas and put an
indicator there.

I can use that column of indicators for lots of things that format|conditional
formatting (and pictures) can't be used.



BigPig wrote:

"Dave Peterson" wrote:

Have you thought about using Format|Conditional formatting.

Maybe changing the fill color would be sufficient.

Yes, however, it wouldn't be sufficient. The form is the kind that is
scrutinized. So anything that is too much out of place would not be received
well. What I have thought about was to create an image of the word "His", and
in paint draw a thick line through it and save it. Then find a way by using a
formula or macro to insert it in a certain cell. The problem is I don't know
how I would go about doing this via macros. And I want to keep the form
organic. Meaning, I don't want to put it in a folder with the images. Would
it be possible to place the image(s) in cells in another worksheet and then
devise a macro/formula to draw from that? Do you have any suggestions?

Thanks again!

--

Dave Peterson