Showing posts from March, 2010

Microsoft excel macro to compare two column for each row and highlight cell with condition

This Macro was tested with Microsoft Excel 2007. Sub compare() ' Select first line of data. Range("B2").Select ' Set Do loop to stop at empty cell. Do Until IsEmpty(ActiveCell) ' Check active cell for search value. If ActiveCell.Value = Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then ActiveCell.Interior.ColorIndex = 3 ElseIf ActiveCell.Value > Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then ActiveCell.Interior.ColorIndex = 4 ElseIf ActiveCell.Value < Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then ActiveCell.Interior.ColorIndex = 5 Else ActiveCell.Interior.ColorIndex = 6 End If ' Step down 1 row from present location. ActiveCell.Offset(1, 0).Select Loop End Sub Every time you change a value in the cell , you have to run the macro manually. In order to run it automatically, put the script into

Looking for live chat icon

If you are looking for live chat icon or operator pictures or even Header images for your live chat pop up windows, you can come to this URL : Here got some nice live chat icon , operator pictures and Header images, it might suite your help. ---

Download and install Cisco SDM

This is the link where you can download the SDM without need to register an account at CISCO. Although registering the account doesn't cost any money , but still feel annoying while try to get the SDM fast and immediately. So here is the link , which you can click and download without any question. If you need a guide on how to install SDM , here is a good guide. Hope this two page will help you to setup the Cisco SDM at your desktop. Another tips before I forget , if you connect to the device using ssh tunnel, most of the time you will access localhost , remember to use localhost instead of , using ip address will cause the SDM failed to launch. ---

A list of mobile device emulators

If you like me plan to develop a series of application for all kind of mobile device, may be you will need some emulators to test out your application. I found this web site from SUN, it contain a list of mobile emulator. Although it is not so up to date , but still worth to have a look. And also this web site , it contain newer mobile device emulator. If you would like to see how the opera mini work , you can try your web site at these two Opera mini online demo. ---

If you need a regular expression generator ...

If you are a programmer newbie like me , sometime you might need a regular expression generator to help you generate the regexp. I tried a few site and found that this is the most suitable for me , so it might suit you as well - ---

List of Browser ID (User-Agent) Strings

One of my previous post said that you can always check your Browser ID (User-Agent) Strings by visit this web site - and also if you need to find out more Browser ID (User-Agent) Strings , you can visit Now I found another list of browser agent at . Not only a list , they also explain the meaning of the string, if you need to figure our more User agent string, feel free to have a look. ---