Open spreadsheet
ALT + F11
Insert > Module
Paste the following as a function
Function GetColor(MyCell As Range) GetColor = MyCell.Interior.ColorIndex End Function
Done. Now call the function using =GetColor(cellref)
then sort that column
Links and jots of Quinn – web & search marketing and more
Open spreadsheet
ALT + F11
Insert > Module
Paste the following as a function
Function GetColor(MyCell As Range) GetColor = MyCell.Interior.ColorIndex End Function
Done. Now call the function using =GetColor(cellref)
then sort that column
First photo with new SLR ![]()
Looking at using this tool to output site maps from Excel lists…
Planning Your Web Site With GraphViz | Webmaster Tips
Graphviz is an open source program for making site map diagrams. It runs on Linux, Windows, and Mac OS X. The sitemap charts can be generated in many formats: png, jpg, gif, svg, ps, Dia (an opensource program similar to Visio), and others. After installing Graphviz and going through this tutorial, type man dot to get more information on what Graphviz can do.
An example PHP script of how to build a site map directly from a crawl here: http://codecaine.co.za/posts/sitemapping-with-graphviz
Great list of MV testing resources:
http://www.culturalmultivariate.com/multivariate/multivariate-testing-top-10-online-resources/
A simple explanation for why Google prefers a high click thru rate in PPC Marketing.
Need to do secure banking from a dodgy internet cafe – while on holiday….
The Incognito LiveCD is distributed as an ISO image file. Most CD recording software can record this file directly to a CD (note that this is not the same as simply putting the file on the CD, but an option like “record CD image” or “restore CD backup” should be used).
For any marketing tactic besides AdWords, Google Analytics relies on destination URLs (where you send your visitors) to decode the visit.
Getting Google Analytics to Measure MSN Paid Search
See also: PPC Hero
and Porter Interactive
The Right Capitalization Can Make or Break Your Ad
There is a science to writing ads in Google AdWords to maximize your click-through-rate and ROI and using just the right amount of capitalization plays a huge part….