Highlight cells based on values in other cells.
 

Hello all!

You guys have worked miracles before, so I am asking for another. I want to look at the value in Column H, if it is found in Column C and the Value of the first character is equal to either A, B or C, then I would like to highlight it in Column H and bring the term in Column I.


Sheet 2 shows what I am hoping to have happen automatically.

As always, thanks for your help!