CF List Coloring

[Guest]

I have a pretty complicated issue I'm trying to solve. I currently have a
list drop down with about 25 different project codes listed. The list of
project codes(PC) used to create this Drop down is in Column K and each PC
has a fill color based on a Conditional Format related to the cell next to
each them saying if it is in work, completed, or cancelled. What I would
like is if I were to pick a PC from my drop down list that is completed it
would either color that cell or warn me. So I can't figure out how to link
the color from the original cells to the drop down list.

Thanks for any help or direction

 

[Guest]

Sean:
How about just using the cell right next to the dropdown list. Put a
VLOOKUP in the cell, referencing the list in colum K. When you choose PC
"1234", it will return, let's say, "complete". Now conditionally format this
cell for the words "work", "complete" and "cancelled". If you format the
text and the fill as the same color, you will left with just a color so you
won't see the word "complete".