Highlighting different letters in a column

viralnerd

New Member
Joined
Oct 11, 2006
Messages
2
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.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

Welcome to the board.

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

plettieri
 

kkknie

Well-known Member
Joined
Apr 29, 2002
Messages
677
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
 

Forum statistics

Threads
1,136,276
Messages
5,674,790
Members
419,525
Latest member
mountainkids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top