Copy conditional formatting across multiple rows?

G

Guest

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
 
B

Bob Phillips

Gil,

R3C3 is absolute referencing.

You can either switch to A1 notation (Tools>Options>General uncheck R1C1
Reference Style) and use a formula of =C3="No".

Or you can use relative referencing, so if the CF is in A1, you use
=R[2]C[2]="No"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top