I have two columns. I want to have some sort of conditional format in the second column that highlights anything that is also in the first column. What it the easiest way to accomplish this. WHen I try conditional formatting I select the column that I want to highlight then i choose the range of the column I am looking up against and the system tells me to change to reference a single cell. Please let me know if you have any ideas.
Thanks
Thanks