Author Archives: Michelle Sullivan

About Michelle Sullivan

Online and search marketing professional

Excel – Highlight Cells That Meet Specific Criteria with Conditional Formatting

Last Updated August 29, 2017 by Michelle Sullivan

How to use MS Excel conditional formatting to change text/background colors of cells automatically

Excel conditional formatting

When doing some Excel-based marketing report, whether it’s web analytic report or sales related report, most of the times, I used some conditional formatting to automatically highlight cells that meet certain criteria such as highlighting cells of under-performing or over-performing shops, under/over-performing regions for revenue reports; highlighting cells based on contract value; highlighting cells that have “N/A” or negative numbers; or highlighting cells of web pages that have poor performance in page visits for a certain period of time. Read more...

How To Use Adobe Acrobat Professional 9

Last Updated May 24, 2013 by Michelle Sullivan

How to use Adobe Acrobat Professional from creating a PDF document, inserting or deleting pages, to creating and editing bookmarks

Creating a PDF document

The free Adobe Acrobat Reader is to read/open a PDF file; to create a PDF document, you need Adobe Acrobat Writer, also called Adobe Acrobat Professional, which is not free. With Adobe Acrobat Professional installed, you can convert almost any type of documents into a PDF by using menu File > Print then select Adobe PDF as the printer; hit OK and you’ll have a PDF document. Read more...

Fix MS Word 2010 to PDF Link Problem

Last Updated September 28, 2012 by Michelle Sullivan

Simple way to fix broken links in PDF after converted from Word 2007 or 2010

I’ve lived with this bug for quite a while, just now decided to write a short post about fixing the broken links and broken text problem after converting MS Word 2010 document to PDF. If you don’t experience this issue, then lucky you, if you’ve been noticing the issue, then read on as the fix is very simple. By the way, there’re all sorts of issues with Office 2010, another one is the printing issue with PowerPoint 2010. Read more...

Google Places “At a Glance” Wrong Description

Last Updated February 23, 2012 by Michelle Sullivan

Google displays wrong information under your Google Places “At a glance”? Find out why and how to fix it

Google Places has been around for quite some time. Since my first post about how to use Google Places to your local business advantage, there have been questions regarding the accuracy of the information displayed under the “At a Glance” section on the Google Places page. For many people/websites, the descriptive terms are insufficient; for others, they are inaccurate and sometimes to the point of providing incorrect information that the owners have never provided while listing their businesses on Google Places. Read more...

Favicon Library #3 – A Collection of Favicons

Last Updated February 3, 2012 by Michelle Sullivan

Here’s the thrid list. You can use the links below to navigate to see more favicons. Hopefully, you can find one that fits what you need. If you see some icon that you like, you can just right click on the icon image and save it to your desktop. In part 1 of the library, I also include a link to an old post on how to add favicon to your site, which can be helpful.

Favicon library 1 | Favicon library 2 | Favicon library 3

Read more...

Favicon Library #2 – A Collection of Favicons

Last Updated February 1, 2012 by Michelle Sullivan

Here’s the second list. You can use the links below to navigate to see more favicons. Hopefully, you can find one that fits what you need. If you see some icon that you like, you can just right click on the icon image and save it to your desktop. In part 1 of the library, I also include a link to an old post on how to add favicon to your site, which can be helpful.