Row font color to Match color of font in column D cells that will change IN DROP DOWN BOX.

I am looking to have the cells font color in each row match the color of the font in column D that will change depending on the info of the drop down box.
sheet 2 is the one I am looking to work with as a test.

Thanks gang....

You are using Conditional Formatting so you should be familiar with the set up:

Using conditional formatting,
>Use a formula to determine which cells to format
then enter the formula " =ISNUMBER(SEARCH("DOE",$E1)) " - and set up the colour.
and then "Applies to" should be eg A:E,L:Z - repeat for other colours


Let me know if you need further clarification

Regards

Alastair

Alastair,

Thanks a great deal for your help.
it was the ISNUMBER part of the formula I could not find when I was working on my sheets before your help. It is working the way we needed it to now.

Thanks A LOT,

Jerry