Conditional Formating

  • Thread starter Thread starter Going Crazy with excel
  • Start date Start date
G

Going Crazy with excel

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.
 
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.
 
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.Apply the same formula to ranges:
AK15 AK22
AL15 AL22
etc.
Hope this helps
 
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?
 
Copy the format. (easiest way is the format painter)

Or, select all the cells of interest, and then apply the conditional format.
 
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?
 
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 rightclick>PasteSpecial>select '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.
 
Back
Top