spreadsheets

Google Docs spreadsheet script: compare dates, highlight past dates, highlight weekends, and highlight today

ORIGINAL PROBLEM I spent hours tonight struggling with this Google Apps script I wrote to serve as custom functions or advanced macros. I adapted it from this StackOverflow post. The main issue I ran into was comparing dates. Here is my research path, and hopefully, some indicator as to why it took so long: STEPS […]

Google Docs spreadsheet script: compare dates, highlight past dates, highlight weekends, and highlight today Read More »

Zemanta Puts Unwanted HTML Comments In Pre-Formatted PHP Code (Sourcecode) In WordPress Posts

PROBLEM: I  have recently determined through trial and error and process of elimination that Zemanta is responsible for adding extraneous HTML comments to my pre-formatted (with “pre” tags) PHP code that I have placed between “sourcecode” tags to activate WordPress.com’s built in programming code syntax highlighting. Here is a screenshot (fig 1.) that demonstrates the

Zemanta Puts Unwanted HTML Comments In Pre-Formatted PHP Code (Sourcecode) In WordPress Posts Read More »

microsoft-office-2010-02_popsilla_01

Excel 2003 – Change Cell Color Without VBA, Using Conditional Formatting.

2012.02.10 (NOTE: This article is currently just a stub … ) So, this is what I was up to tonight.  I researched and learned the following techniques: Excel data validation list from named range in another worksheet Build drop-down menu in Excel How to delete duplicate rows using in-place filtering Keyboard shortcut for entering and opening

Excel 2003 – Change Cell Color Without VBA, Using Conditional Formatting. Read More »