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.