Conditional format within a loop

Joined
Nov 23, 2005
Messages
6
I am trying to add conditional formats within a loop. I can get this to work for a range and copy down but not elegant!

How do I do this for cell offset.

PS only my fist week in VB so any help welcomed

KG
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Can you explain why you can't add them all in one go? ( i.e. explain exactly what you mean by "I can get this to work for a range and copy down"? )
 

Watch MrExcel Video

Forum statistics

Threads
1,118,086
Messages
5,570,136
Members
412,305
Latest member
Mozz
Top