Highlight-non-exist-values-in-Excel


What does the code do?

Assume we has a Excel table like example.xlsx. We need to check whether the values in column B and C exist in column A.

If the values in column B and column C does not exist in column A, the corresponding cells will be coloured to red.

image

image


Declaration

I’m a new learner of python coding, so the code has many potential problems like slow speed because of loop.

If you have any idea to achieve the same result in an easier way, please leave a comment!

Thank you.

GitHub

View Github