You did not mention your version.

XL2003:

Assume the range of cells to be formatted is A2:G6 and column A is the key
cell to check.

1) Click on Cell A2. While holding down the [Shift] Key, click on A6 - so
the whole row required to be formatted is highlighted and the first cell
(A2) is active.

2) Click Format, conditional Formatting.

3) Change condition 1 dropdown to 'Formula Is'

4) Enter the formula =ISBLANK($A2)

5) Do not select any formatting

6) Change condition 2 dropdown to 'Formula Is'

7) Enter the formula =$A2=0

8) Click the Format... button for Condition 2

9) Click the Font tab and check the Strikethrough box

10) Did you want red text or background?

11) If red text, one the font tab choose red in the color: dropdown.
Otherwise, click the Patterns tab and choose red.

12 Click OK until back at the main sheet

Now use the format painter to paint the format to the rest of the range. If
you don't know how to use the format painter, copy the row, Highlight
required cells below and Paste Special; Formats


Omit steps 3-5 and move the other steps to condition 1 if you also want the
highlight to appear for blank cells.

HTH
--
Steve

"Joel" wrote in message
...
I have a small offset group of cells on the edge of my main spreadsheet
which
details my monthly bills.

When a bill has been paid and reads 0 I want it to turn red and put a
strikethrough that row. Not the entire row just part of the row that shows
that my little table on the edge of my spreadsheet.

Regards and thanks in Advance
--
N/A