Formula for IF = THEN

[JL Summerlin]

Good morning. I am working in an Excel database I have
recently created. I need to create a formula that allows
for a specific cell to change colors once a different
cell has selected a specific value from a validated
list. Is this possible?

Ex. Cell AC14 is validated to a list of employee names.
By selecting "Alex" from this list, I then want cell AM25
to change color from its current format to "gray".

 

[JL Summerlin]

Wow! This worked great. Thank you so much.

However, I have 32 employee names in a list. This list
is validated in 30 different cells. I want each cell to
select a single name from this list, then change the
color of the cell below corresponding tho the name
selected. CONDITIONAL FORMAT allows for only 3
conditions. Is there a way around this somehow?

Otherwise, is there a way to remove a name from
the "list" once it has been selected?

 

[Anon]

Wow! This worked great. Thank you so much.

However, I have 32 employee names in a list. This list
is validated in 30 different cells. I want each cell to
select a single name from this list, then change the
color of the cell below corresponding tho the name
selected. CONDITIONAL FORMAT allows for only 3
conditions. Is there a way around this somehow?

Without writing VBA code, you are limited to the three conditional formats.

Otherwise, is there a way to remove a name from
the "list" once it has been selected?

Take a look here for how to do this:
http://www.contextures.on.ca/xlDataVal03.html
Whilst there, have a good look around. You won't find better on data
validation.