I am importing large amounts of single letters into excel and then manually highlighting those within a column that are different. Can this be done with a macro? For example, I might have 50 rows per column and 45 rows might be 'A', 3 might be 'G', 1 might be 'I' and one might be 'V'. Is there any way to highlight the first difference with yellow background (3 G's), the second difference with a red background (1 I), the third difference with a blue background (1 V), etc?
Thanks for your suggestions.
Thanks for your suggestions.