Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if a condition is met I want an x in a cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if a condition is met I want an x in a cell
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. "scheduler" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if a condition is met I want an x in a cell
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 "Barb Reinhardt" wrote: 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. "scheduler" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
How to change the value of a cell when a condition is satisfied, but not otherwise? | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |