Try Putting conditional formatting with formula =COUNTIF($A$3:$A$18,"=" & B3)>0 where B3 is your starting cell and $A$3:$A$18 referes to the data to be checked
A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
|
Compare 2 columns to another sheet & highlight matches Compare one column with another and show differences Compare two columns in excel Excel compare two columns for matches Excel copy multiple columns into one column Excel filter cells in one column if another column is empty Excel formula compare tow columns return count Excel formula multiple values one column single values other column Excel formulas for counting unique entries in one column How to add two names in one column in excel How to automatically transfer data from one column in a workbook to another How to compare two columns in excel How to move data from one column to another in excel How to print one column values in row in oracle Macro for comparing two columns of a one worksheet to another worksheet Moving data from one column to another according to criteria in another column excel Sort one column into multiple in excel Vba to compare to columns and extract matching data