Am trying to match the values from Sheet1 and Sheet2, if the Sheet1 values in all columns matching with Sheet2 have to insert a new column named ‘status’ in Sheet1 and update as ‘Match’ with green color.
If any value in the particular column is not matching, that needs to be marked with ‘yellow’ color and ‘status’ value should be updated as ‘NoMatch’ with Red color.
Have attached the sample excel.
Please assist with above workflow or sample, i tried few types, however am able to match the values but unable to set the color to output data.
Thanks in advance,
Surya17-02-2020 - Copy.xlsx (9.2 KB)