Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gil
 
Posts: n/a
Default 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
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing conditional formatting when saving Eric FD Excel Discussion (Misc queries) 3 January 19th 05 12:42 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 02:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? Likepike Excel Discussion (Misc queries) 2 December 21st 04 05:02 PM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 8th 04 12:02 AM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"