Conditional formatting of a column of cells

Hello,

I am working on a task list/project sheet and I am trying to set a conditional format for a column of cells that is based on two (technically three I guess) conditions to highlight the expected due date if:

1) The date in the cell is prior to Today (all values are dates) highlight red and change text to dark red

2) AND The value in the adjacent cell does not equal "Complete" turn the text bold

3) If the cell is BLANK apply no formatting (meaning I haven't added a task to that row yet)

I can get the color to change using a conditional formating rule on that column "Formula is < TODAY()"

but I can't figure out how to get the relative value to bold the text based on whether the value of the cell next to it is NOT the word "Complete". For some reason it's using the absolute position or value of the first cell in the column.

I also can't figure out how to keep it from formatting if blank.

To help - the expected due date values are in G2:G200 and their corresponding completion status are in H2:H200.

I am using Excel 2007, latest patch.

Thanks in advance your expert guidance!