I have checked with the Menu> Format> conditional Formatting.. but when data changes all setting gone...
so I am looking for code in macro. so that if new data comes on table2 need not not to do all settings again !!
I am beginner with excel bare with me and help me to get solution for below
I have 2 tables- table1 and table2.
table 1 has 2 columns only col1, col2. it is the reference table for comparing values.
table 2 has 200 columns. It is data table.
I have to compare reference table(table1) with...