Hi all, Excel 2010 novice attempting to highlight cells with different values but potentially can be duplicated in a row (D2:AQ2) if the cell value has the same as that of cell values in a column (B9:B32)......any help would be much appreciated!