Applying conditional formatting to dynamic range

[Arup C]

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.

 

[Don Guillett]

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