What you are describing (so far) does not sound like any programming would
be necessary... it could be handled by simple formulas placed in B1 and
"copied down". However, whether you might actually need more than simple
worksheet formulas kind of depends on what all those dots mean after "Susan
has April". Can you specify for us in more detail what your actual needs
are?

Rick


"mommatee" wrote in message
...
Is there a way to set up Conditional Formatting (or something else) to put
text in a cell if a certain condition is met?
For example if Paul has January & Susan has April............
A1 is January then B1 automatically fills in Paul
A2 is April then B2 automatically fills in Susan
A3 is April then B3 automatically fills in Susan
A4 is April then B4 automatically fills in Susan
A5 is January then B5 automatically fills in Paul

I don't understand programming enough so I'm trying to find out if there
is
something else I can do. Thanks in advance!