Hayley performs the classics

Hayley performs two classic movie scenes:

Chinese for Sorry

Kid: "duì bu qǐ" is Chinese for "sorry."

Mom: So that's what you say if you hit somebody?

Kid: No, that's what you say if you hit a Chinese person.

Open Office: Is there an easier way?

Question for any OpenOffice/StarOffice spreadsheet users (and perhaps Excel users):

Q: I want to format an entire row based on the value of one cell in that row. I found one way, but is there an easier way?

I'm using the Conditional Formatting feature. By default it only formats a single cell based on that cell's value, but I made the following changes to format the entire row based on the value in COLUMN "Q".

In this example, if the cell value in COLUMN "Q" is "yes" then I change the style for the whole row to "My Style."

1. Go to Styles and Formatting from Format menu.
2. Define style "MyStyle"
3. Select all of the rows I want this to affect.
   
4. Go to Conditional Formatting from Format menu.
5. Change condition to "Formula is"
6. Use the following formula:
• EXACT(INDIRECT(CONCATENATE("Q";ROW()));"yes")
7. Set the style to "MyStyle"

This works but hard codes the column value of "Q." If I add or delete any columns before Q then the formatting turns off and I have to go in and change the value. Not a huge problem but this doesn't seem very elegant. Also, you can only have up to three conditions per cell, so that makes for a maximum of only four possible states (formats).

So, are there any better ways of doing this?

Kid on Fund Raising

News: Story about politicians raising money.

Kid: How do you raise money? Just lift it in the air?

Me: Ha ha. No, it means they are asking people to give them money.

Kid: That's kind of like stealing, isn't it?

Yoda Drawing

Yoda Drawing, originally uploaded by K Chu.

Kid drew this picture of Yoda holding his light sabre and a cup.

Ironic Juxtaposition

People stealing food in Greece while people in Spain waste it.

TIE Footer

TIE Footer, originally uploaded by K Chu.

Hayley put the ball between her feet and said "Daddy! TIE Fighter!"