Monday, November 30, 2009

Sweet November

It was sure nice to have a streak of days off to rest during the Thanksgiving holiday. The best part of my time off was making a table runner for my mom-in-law, Maggie, who's birthday was coming up and sharing the end of the month with family.

Grandma, Aunt Jan, and Cleo drove in from California and we were also joined by our friend Shannon. He brought with him a beautiful tropical bouquet and great-cousin Caroline sent her love with a pie and a gorgeous centerpiece for the dinner table.

John put together this delicious citrus salad (he won't let me forget the time and care he spent in kitchen slicing and separating the orange and grapefruit slices, LOL!! It was hard work indeed.)

We both admit the amount of effort put forth into making the salad and table runner was not even close to what Grandma, Maggie, and Aunt Jan prepared for dinner. The apple pie, mashed potatoes, green beans, sweet potatoes, caramelized onions, cranberry sauces, pumpkin pie, gravy, and of course the turkey was truly a fabulous feast!

One-and-a-half plate, a slice of pumpkin pie and a cup of tea later, I felt like rolling over on the carpet just like Yazzie to take a nap! I don't know where Bindy Sue and Cleo went...they must have already retired to bed.
Post-Thanksgiving Dinner
This was indeed a sweet November and I am thankful not only for the delicious dinner but for the family and friends I was surrounded by who made the meal and Thanksgiving so meaningful. Whatever tradition you have to celebrate the holiday, I hope you also had a wonderful weekend.

Photos from the Picasa album "Thanksgiving".

Wednesday, November 18, 2009

Not so brown after all

Since I can't seem to grow anything green that's not mold, I gave up on gardening and indoor house plants...including cacti. Somehow this yam is thriving so my thumbs are not so brown after all...well one of them.
Sent via BlackBerry from T-Mobile

Saturday, November 07, 2009

Tuesday, November 03, 2009

How to hide #N/A errors in Excel 2007

I work in Excel quite a bit, analyzing data and writing formulas. At times, the formula results in an error displayed as #N/A instead of a value. When I'm working with columns and rows filled with data, these annoying errors can make me go cross-eyed. I created a simple example to show you what I mean (click on any image to display a larger view).

How can I hide these errors from displaying? Many of the help articles and forums out there will suggest using Conditional Formatting and then some =ISERROR() code which hides errors in a single cell or, personally, I've find confusing to follow.

I need to know how to hide these errors quickly without needing to break out a formula since I haven't got all day. I've found an easier way; at least it works for me and will show you how to hide these #N/A errors in 10 steps or less -- the user-friendly way! (Note: you don't want to delete the #N/A errors so when the error is resolved, the value will display. I'll touch on this again after step 6.)

Here is how to hide #N/A errors in Excel 2007 in 10 steps or less:
1) Select the column(s) containing the errors
2) Select Conditional Formatting from the Home ribbon
3) Select New Rule... from the submenu

4) Select a Rule Type: Format only cells that contain  (Here is where other articles will tell you to choose "Use a formula to determine which cells to format" which would be fine and dandy for more complicated selection criteria but, dude, we have a simple error here.)
5) Edit the rule description by selecting Errors from the drop down list of values under Format only cells with: and click Format... (Note the other options like Blanks, Specific Text, etc. for future reference)

6) In the Font tab, select White for the background color under the Color drop down menu (assuming your cell or worksheet background is white; otherwise select a matching color) and click OK until you are back to your spreadsheet.

Notice the #N/A errors are still there but the text color formatted to match the background. When you click out of the column the errors seem to disappear (remember that if the error is resolved and returns a value, the conditional formatting rule will not apply so the text will display--this is why you don't want to delete the #N/A errors just to keep them from showing on the spreadsheet)! Viola--I explained how to do this in 6 steps.

But what about the annoying green flags at the corners of the cells containing the errors? Follow me and I'll show you how to hide those too.

7) Click the MS Office icon at the top left of the Excel window.
8) Select Excel Options

9) Select Formulas from the options list on the left.
10) Under Error Checking, select White from the paint bucket icon where it says, Indicate errors using this color and click OK.

Your spreadsheet should now show ... or should I say hide the #N/A and green flag errors. Pretty simple I think, or at least more intuitive than having to remember a formula.

Next time I'll show you how to reference an array, match data and return a value from the same row to display on a new sheet using named ranges, a couple formulas, =INDEX and =MATCH. Trust me, it's easier than it sounds and will save you a lot of time if you are comparing data or cutting and pasting data that matches.

Dubble Bubble

I've noticed that more and more grocery stores have stopped carrying bubble gum. I don't mean the minty chewing gum...but BUBBLE gum. They're so much fun to chew!

Lately I've been finding clusters of these around the house, just waiting for me to unwrap them. :-) I think somebody loves me.
Posted by Picasa

Brighter side of fall season

Besides ushering a slew of holidays, the fall season also brings daylight earlier in the morning... I can meet John for coffee before starting my day.
Posted by Picasa

Sunday, November 01, 2009

Wild Buffalo Wings at Balboa Pizza Company

Hear me shudder like Homer Simpson...ooh this is going to be spicy and GOOD!!!