Hi all again
Quick one (I hope).... If i have two columns, what would be the best way to compare all the values in these two columns and if any values exist in both columns, albeit anywhere in these columns, then the cells in both columns are changed to green, whereas any cells that dont exist in both columns are changes red? Any suggestions? I can't think how to go about this.
Many Thanks in advance