ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy conditional formatting across multiple rows? (https://www.excelbanter.com/excel-discussion-misc-queries/3496-copy-conditional-formatting-across-multiple-rows.html)

Gil

Copy conditional formatting across multiple rows?
 
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

Bob Phillips

Gil,

R3C3 is absolute referencing.

You can either switch to A1 notation (ToolsOptionsGeneral 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)


"Gil" wrote in message
...
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





All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com