if a condition is met I want an x in a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scheduler - 25 Oct 2006 15:51 GMT

I am making a list of names that are to be placed in a schedule and as those
names are used I want an "X" to appear in a list of days in the week to know
when scheduled

Reply to this Message

Barb Reinhardt - 25 Oct 2006 17:56 GMT

You'll need to be more specific on what you want. Where do you want the X
to appear and what do you want to base it upon ... cell ids would be helpful.

> I am making a list of names that are to be placed in a schedule and as those
> names are used I want an "X" to appear in a list of days in the week to know
> when scheduled

Reply to this Message

scheduler - 25 Oct 2006 21:20 GMT

Column A-G: Each column represents a day of the week. Each cell would
represent a scheduling spot, say 1-12= 12 spots
Column H blank
Column I = Names of employees
Column J-P = each day of the week
As an employee is placed in a spot in columns A-G, I would like an X to
apear next to the employees name for each day scheduled.

Example: If employee in row 1 is scheduled for day A,B,C, an "x" would apear
column J,K,L on the row as the employees name

Hope this makes sense

> You'll need to be more specific on what you want. Where do you want the X
> to appear and what do you want to base it upon ... cell ids would be helpful.
>
> > I am making a list of names that are to be placed in a schedule and as those
> > names are used I want an "X" to appear in a list of days in the week to know
> > when scheduled

Reply to this Message