Highlighting different letters in a column

[viralnerd]

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.

 

[plettieri]

Hi:

Welcome to the board.

One method might be to auto filter the cells of interest then highlight as needed.

plettieri

 

[kkknie]

Select all of the data and choose Format | Conditional Formatting.

For the conditions, use Cell Value is, equal, A
Then hit the format button, select the patterns tab and select the background you want.
When done, hit Add and add the next condition the same way.

This will work for up to three different conditions. After that, the only way I know how to do it is to write a little code.

Hope this helps,

K

 

[viralnerd]

THANK YOU!!