View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xllearner xllearner is offline
external usenet poster
 
Posts: 1
Default Need help in highlighting the cell color in VBA


Hi All,

I am new to the excel VBA. Your help is appreciated. Please Help me in
vba code for the following points.

I have attached the sample file of how i get and what changes would
required once after i run macro in the excel.

1) Sum to column.
2) If city code numbers are same then highlight the cell backgaround
color.
3) Merge the cell and highlight with the color.

Note: Data may vary. eg If today i am getting 100 tomorrrow it may
1000.

Regards
Praveen.


--
xllearner
------------------------------------------------------------------------
xllearner's Profile: http://www.thecodecage.com/forumz/member.php?u=1961
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=206560

http://www.thecodecage.com/forumz