Need a simple recommendation

[Guest]

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

 

[Don Guillett]

Wouldn't a column with s or a work?

 

[Guest]

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.

 

[PCLIVE]

Hi Karen,

Do you already have a check box in column C? If not, then just eliminate
that portion. Sticking with column D as the "s" or "a", with the
appropriate items marked with "a" or "s", hightlight the column that you
would like to change colors based on the contents of D.
Then goto Format-Conditional Formatting.

Use:
Cell Value Is - equal to - "s"
Then select the Format button and adjust the appropriate format settings.
Font, of course, will be your text format (bold, color, etc.)
Patterns will be your cell background color.

HTH,
Paul

 

[Guest]

Paul,
Thanks for info.... but the spreadsheet is something that is updated as each
item is sold..... if i was just sorting existing data, then I could simply
sort the columns and change the data within each column. Maybe I needed to
be more specifice - sorry.

As the item is "sold", the user would need to check off that item as "sold",
then change that row to show that it has been "eliminated/sold" (but still
visible) from inventory.

Since this happens quite frequently, I was hoping to "automate" the process
so the user would just "check a box" and the row would "highlight" or change
colors or something....... I have several people that have no computer
skills what-so-ever (not that mine are much better )...... I need to
make it simple, yet usuable.

Thanks - (again) for everyone's input.