I have three Lists;
1. Advisers and annualised premiums in 2014
2. Advisers and annualised premiums in 2015
3. The difference between list 1 and 2
Lists 1 and 2 need to be sorted by annualised premium, highest to lowest.
List 3 only includes the advisers from list 2.
List 3 shows the difference between annualised premium in list 1 and 2. If the premium is higher the row needs to be green. If the difference is lower the row should be red.
if the adviser is in list 2 but not in list 1 then the row should be yellow but it should also include the annualised premium in list 2.
How do I make this happen?
1. Advisers and annualised premiums in 2014
2. Advisers and annualised premiums in 2015
3. The difference between list 1 and 2
Lists 1 and 2 need to be sorted by annualised premium, highest to lowest.
List 3 only includes the advisers from list 2.
List 3 shows the difference between annualised premium in list 1 and 2. If the premium is higher the row needs to be green. If the difference is lower the row should be red.
if the adviser is in list 2 but not in list 1 then the row should be yellow but it should also include the annualised premium in list 2.
How do I make this happen?
