Case-Sensitive Conditional Formatting (in range)

[ykobure]

I found a thread here bearing the same title as above, however the solution the experts here provided do not suit to my requirement, so I created yet another thread for case-sensitive conditional formatting.

What I want to achieve is this:

• Cell E2 has data validation list range from A2:A53
• Cell F2 has data validation list range from B2:B53
• As value is selected, the code automatically look up the code corresponds to it
• With a simple Conditional Formatting, what ever value is selected in cell E2 will automatically highlight the same value in column A
• I also want to do the same in column B. However, the problem arise since upper and lower case characters are treated as the same
• If I apply the same Conditional Formatting as in column A, the upper and lower case get highlighted.
• I know it can be done, but I do not want to do it in every single row.
• Is there a way I can accomplish this without resorting to create a Conditional Formatting in every single row?

I attached the sample workbook for your reference.
Book1.xlsx

Thanks in advance!

[ferry2512]

Sorry for deleted my post, for Case Sensitive, I have same problem.