I want to code my excel so that it will copy the data from multiple cells to another location using conditional formatting. For example, if the word in cell D4 is not equal to the word in cell E4, I want it to copy cells B4, C4, D4, and E4 to another location on the document. Furthermore, I would like to have this run through multiple rows without leaving spaces in the "copied" area. I could code it as an if statement (which would take forever because i have a lot of data) but I don't think it would allow me to have as many in-bedded if statements as I need.
Thank you for your help!
Solved by K. L. in 20 mins