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.