I am using Excel 2003 and have created conditional formatting on the first
row in the worksheet with a formula as follows =R3C3="No". This works
correctly and the formatting of the row works as expected.

If I now copy the formatting to the row below, using the 'Fill formatting
Only' option when pasting the formatting is still based on the cell
referenced in the intial formatting.

Is there anyway to reference column 3 more generically in the formatting
formula so I do not have to modify the formula on every row?

TIA

Gil