0
I have two tables in 2 excel files, and I want to compare each value of the A column of the file_1 with each value of the A column of the file_2 and also each value of the F column of the file_1 with each value of the H column of the file_2. If equality is found in both cases, then the field in file column F 1 should change color.
Each value of each column will compare with all values of the respective 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.
}
If you post an example, with images or some data can help a lot. I think you could try using PROCV for that reason...
– Evert
The PROCV should be in conditional formatting for this... take a look at a template here: https://github.com/excelguru/controle-obligato/raw/master/Controle%20of%20Obrigacoes.xlsx
– Evert