View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_27_] Michael[_27_] is offline
external usenet poster
 
Posts: 41
Default Coloring cells with same values using VBA?

Hi,

Say in an Excel column I have this:

B1 12
B2 12
B3 4
B4 7
B5 4
B6 12
B7 7

and want to use a VBA piece of code to give same color to those with
same value. How can I do so please?

Regards,
Mike