Yes Don of course, but i'm looking for a "visual" solution - i.e. colored
coded text or cells, or something to that effect.

I realize it seems redundant, but it's at a supervisors insistence... not
mine :) he wants the "check box" effect ????? go figure......

Thanks.
--
Karen


"Don Guillett" wrote:

Wouldn't a column with s or a work?

--
Don Guillett
SalesAid Software

"Karen" wrote in message
...
Greetings Everyone!
I haven't used Excel in a while and i'm pretty rusty. Any suggestions are
greatly appreciated.

Need a formula or macro that does the following....

In an inventory of items, I need to be able to "check off" a item that is
sold, have that cell "change color" (or something equivalent or "s" to
indicate sold) to indicate that the item was sold. I will need to be able
to
sort the columns to keep track of "sold" vs. "available" items..

i.e...... something along these lines....

A B C D
1 item1 price ck box result "s"
2 item2 price ck box result "a"
3
etc..... if i check c1, then the result in d1 will equal "s" for sold,
if
not, then "a" for available.

Any help or suggestions on the best way to resolve this is appreciated!
Thanks!
Karen