Compare column and update/set color

Help Studio
, ,
1

Good day everyone!
It is necessary to compare the result of the excel file with all excel files in the input files and, depending on the matches, do the actions (described below).
Created a database (consolidated_DT) based on the excel file result. Next, I add the data from each Excel file to the out_data database.
Now I want to compare the out_data data with consolidated_DT, then change the color of the cells and update the data in excel files. Please help me implement the comparison, I think to do this:

  1. Look at the “Cadastral (or conventional) number:” column, if it matches, then compare the data in this row by columns (the columns can be in different order).
    1.1. If the value from the excel column of the result file (consolidated_DT database) matches the value from the excel file (input folder, out_data database), then highlight the cell in green in the compared file (input folder).
    1.2. If the value from the excel column of the result file (consolidated_DT database) does not match the value from the excel file (input folder, out_data database), then substitute the value from the result file into the compared file (input folder) and highlight the cell in red.
    1.3. If the value from the excel column of the result file (consolidated_DT database) is “ValueNotFound”, and the excel file (input folder, out_data database) contains a value in this column, then simply highlight the cell in the compared file (input folder) with yellow color.
    CompareColumn.zip (55.5 KB)
2

I supplemented it by comparing the values ​​in the “Cadastral (or conventional) number:” column, but I don’t know how to color green only matching cells.
Main.xaml (13.2 KB)