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!