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