I am looking for a procedure to cover the following requirements and add it to my personal.xlsb
1-Inputbox: “Enter & select the header range which is going to receive the comparison”
2-Inputbox: “Enter column letter for first comparison column”
3-Inputbox: “Enter column letter for second comparison column”
4-Perform a comparison row by row between first column and second column and reported TRUE when it is equal FASE when it is FALSE. For FALSE values report fill the various range with red colour
5-For header value related to 1- perform concatenation between header of first comparison column header & “vs” second comparison column header
I attached dummy file.
If you have questions, please contact me