Conditional Formatting Question

[mommatee]

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!

 

[Rick Rothstein \(MVP - VB\)]

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]

I posted the following question last week but it was moved to the Excel
Pogramming board. This is actually more like what I'm trying to do. The
discription I gave with the months & Susan/John was made up (I was trying to
simplify my example)

Each person in my dept (approx 10 people) are assigned codes that they are
responsible for. For example: John Smith's codes are 080, 116P and 114.
Jane Doe's codes are 115AB, 11D, 10PI and 1586D, etc.) If someone needs to
get information on someone else's code, we send them an email. To eliminate
having to send emails, I'd like to create a shared worksheet that allows each
of us to type the code needing information in column A. I'd like the cells in
column B to automatically fill in the person that's responsible for the code
typed in column A.

So, if I type the following in column A, I'd like a formula (or something)
to fill in column B. I don't want anyone having to look up the person that's
responsible for the code thats in column A
(A1) 11D (B1) Jane Doe
(A2) 116P (B2) John Smith

This will tell Jane Doe to provide whatever info is needed on her code 11D
and John Smith will provide whatever info is needed on his code 116P.

I basically want to do something like conditioning formatting/formula (not
comfortable with programming).

Thanks for any help anyone can give me.