• Highlight cells based on values in other cells.

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

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