Excel 2007 Conditional Formatting

[THECORBYLOON]

I have a spreadsheet listing checks and I have applied a conditional format to a row so that it changes colour when a cetrain cell has the value of "0." Ma question is, how do I apply that to all the rows below it?

Ta.

[HWKE]

Highlight the row where your conditional formatting has been set and then go to the menu bar and look for an icon which looks like a brush (about a quarter of the way along from the left). It is called format painter. Double click it. Then every cell you click on will adopt the format until you click the icon again. So you can click on the numbers down the left hand side and apply the formatting as you require.
If you only wanted to copy the format of one cell to another cell, you would only need to click the icon once. As soon as you click on the cell you want to copy the formatting to, it will copy the format then cancel the command.

[THECORBYLOON]

Thanks for that, the format painter rings a bell but it's not doing what I want. I don't think it was clear what I want to do.

I have it so that when $G$7=0 the row turns yellow but what I want is the formula to change to match the cell so that $G$8=0 and so on. I tried what you said but it seems to have replicated the $G$7=0 in all the cells in column G.

[THECORBYLOON]

I've sussed it now by removing the "$" before the cell number.

Cheers HWKE