• Highlight cell values in other areas based on two columns

    From Lee Radney@21:1/5 to All on Sat Aug 8 11:06:38 2020
    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!


    https://drive.google.com/file/d/1sBYLIeRS2WQp2jA0Zs1Ld8BtsIywzk7_/view?usp=sharing

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)