Help
cancel
Showing results for 
Search instead for 
Did you mean: 
Copilot Lvl 2
Message 1 of 2

Excel raw compare

Solved! Go to Solution.
Hello. There is excel file with 5 columns and 1000 raws. Looking for a code that will compare 2 columns. It is columns with database logins and LDAP logins. If value of column 1 differ of column 2 - paint red colour this 2 column. will be nice to find this code on github.
1 Reply
Highlighted
Solution
Commander Lvl 1
Message 2 of 2

Re: Excel raw compare

Hey @IgorST91, this post describes a pretty good solution: https://stackoverflow.com/questions/43970265/excel-columns-comparison-using-python-code 

 

I am not sure if Panda's has the ability to write colored columns but that would be trivial to do manually. I hope this helps!