Excel 2010 Conditional Formatting with dynamic linked table
Hello,
I have a dynamic linked table which is working fine under Excel 2010
in lines I have names of shop
in columns year (2010,2011,2012,...)
the result is the amount of sales of the year per shop
I'd like to make a conditional formatting that will simply help me to identify if the result is growing or regressing regarding to the last column (in our case, the last year)
or to use the conditional format data bars
the problem is that I want a conditional formatting for each line and not for all the cells.
I have more than 800 lines so I can't do it manually.
Thanks for your help
I have a dynamic linked table which is working fine under Excel 2010
in lines I have names of shop
in columns year (2010,2011,2012,...)
the result is the amount of sales of the year per shop
I'd like to make a conditional formatting that will simply help me to identify if the result is growing or regressing regarding to the last column (in our case, the last year)
or to use the conditional format data bars
the problem is that I want a conditional formatting for each line and not for all the cells.
I have more than 800 lines so I can't do it manually.
Thanks for your help
ASKER
2010 2011 2012 2013
shop1 50 60 55 52
shop2 100 200 150 250
shop3 400 500 600 550
this is a sample of the table
if I choose to format with data bars all the cells, the bars will be between the value of 50 (2010 / shop1) and 600 (2012/shop3) and this is not good for me
I want data bars (or any else format) for each shop , that means
for
shop1 [50 - 60]
shop2 [100 - 250]
shop3 [400 - 600]
in fact, I want each line format to be separate to the other lines.
I have more than 800 lines ...so to do it manualy is excluded.
regards.
shop1 50 60 55 52
shop2 100 200 150 250
shop3 400 500 600 550
this is a sample of the table
if I choose to format with data bars all the cells, the bars will be between the value of 50 (2010 / shop1) and 600 (2012/shop3) and this is not good for me
I want data bars (or any else format) for each shop , that means
for
shop1 [50 - 60]
shop2 [100 - 250]
shop3 [400 - 600]
in fact, I want each line format to be separate to the other lines.
I have more than 800 lines ...so to do it manualy is excluded.
regards.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your answer didn't resolved my problem because it is not possible to copy line with dynamic linked table.
But it help me a lot to understand the subject.
Regards.
But it help me a lot to understand the subject.
Regards.
Can you explain this a bit further?
Do you have an example of the data and how you would like them formatted?