A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Conditional Formating



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 12:28 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Conditional Formating

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.
  #2  
Old June 4th, 2010, 12:41 PM posted to microsoft.public.excel.misc
Ms-Exl-Learner
external usenet poster
 
Posts: 522
Default Conditional Formating

Actually what this formula will do?

--------------------
(Ms-Exl-Learner)
--------------------


"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

  #3  
Old June 4th, 2010, 12:42 PM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Conditional Formating

Use

=ak$7:ak$11

and copy across

--

HTH

Bob

"Going Crazy with excel"
wrote in message ...
I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.



  #4  
Old June 4th, 2010, 12:46 PM posted to microsoft.public.excel.misc
Jackpot
external usenet poster
 
Posts: 28
Default Conditional Formating

I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

  #5  
Old June 4th, 2010, 01:07 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Conditional Formating

Sorry, probably to early to be asking this type of question. Basically I
want to copy and paste this formula to all similar ranges thoughout the sheet.
=$ak$7:$ak$11
=$ak$4:$ak$6

Apply the same formula to ranges:
AK15 AK22
AL15 AL22
etc.
Hope this helps

"Ms-Exl-Learner" wrote:

Actually what this formula will do?

--------------------
(Ms-Exl-Learner)
--------------------


"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

  #6  
Old June 4th, 2010, 01:11 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Conditional Formating

I think you are on the right track for what I want to do. How do I copy and
drag, just the formula, to other ranges?

"Jackpot" wrote:

I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

  #7  
Old June 4th, 2010, 01:27 PM posted to microsoft.public.excel.misc
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Conditional Formating

Copy the format. (easiest way is the format painter)

Or, select all the cells of interest, and then apply the conditional format.

--
Best Regards,

Luke M
"Going Crazy with excel"
wrote in message ...
I think you are on the right track for what I want to do. How do I copy
and
drag, just the formula, to other ranges?

"Jackpot" wrote:

I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below
are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or
drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.



  #8  
Old June 4th, 2010, 01:28 PM posted to microsoft.public.excel.misc
Jackpot
external usenet poster
 
Posts: 28
Default Conditional Formating

Copy the cell with formulas and paste to the other location...or drag

"Going Crazy with excel" wrote:

I think you are on the right track for what I want to do. How do I copy and
drag, just the formula, to other ranges?

"Jackpot" wrote:

I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

  #9  
Old June 4th, 2010, 01:37 PM posted to microsoft.public.excel.misc
Going Crazy with excel[_2_]
external usenet poster
 
Posts: 16
Default Conditional Formating

When I do this, it replaces the contents of the cell. I want just the
formula to drag and paste not the contents of the cell. What am I doing
wrong?

"Jackpot" wrote:

Copy the cell with formulas and paste to the other location...or drag

"Going Crazy with excel" wrote:

I think you are on the right track for what I want to do. How do I copy and
drag, just the formula, to other ranges?

"Jackpot" wrote:

I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

  #10  
Old June 4th, 2010, 01:42 PM posted to microsoft.public.excel.misc
Jackpot
external usenet poster
 
Posts: 28
Default Conditional Formating

If you are talking about Conditional formatting dont copy paste; select the
entire range before applying CF...OR copy the cell ..select the target range
and rightclickPasteSpecialselect 'Formats' and click OK

If this is not CF ;You can either have a formula or some cell content in a
cell. Cannot have both.


"Going Crazy with excel" wrote:

When I do this, it replaces the contents of the cell. I want just the
formula to drag and paste not the contents of the cell. What am I doing
wrong?

"Jackpot" wrote:

Copy the cell with formulas and paste to the other location...or drag

"Going Crazy with excel" wrote:

I think you are on the right track for what I want to do. How do I copy and
drag, just the formula, to other ranges?

"Jackpot" wrote:

I am not sure I understood your query.

Use relative column referencing after selecting the entire range. Below are
the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
=$ak$7:$ak$11
=$ak$4:$ak$6
I want to repeat this same rule to adjacent columns, AL thru AS.
Then I want to repeat the same rule for the range AK15 AK22 THRU
AS15 AS22.
Is there a way to repeat this same formula without re entering the same
formula throughout the entire workbook?
Any help would be greatly appreciated.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:22 AM.


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