I have two tables in 2 excel files, and I want to compare each value of column A of file_1 with each value of column A of file_2 and still each value of column F of file_1 with each value of column H of file_2. If there is equality in both cases, then the column F field of file_1 should change color.
Each value of each column will compare with all values of its column in the other file.
In pseudocode it would look like this:
if(A1_file1 == A1_file2 && F1_file1 == H1_file2){
F1 muda de cor.
}