If it is a self-adjusting defined name range then just refer to it instead
of the static range.
As always, post YOUR code for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Arup C" wrote in message
...
Hi everybody,
I am working with quarterly sales data on which i have made dynamic range.
The data is arranged like following

Figures in Lac
A B C D
E F
Salesperson 1st qty 2nd qty 3rd qty 4th qty
Total Sale
David 50 70 60 10
190
John 80 30 50 20
180

Now I want to use conditional formatting using macro which will apply
conditional formatting each time I run the macro. But the problem is when
I
am trying to record this macro I am unable to select the dynamic range. It
is
easy selecting static named range but the main disadvantage is that I have
to
change the range every time I add a new record. Is there any solution to
this
problem? Please advice.