View Single Post
  #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.