Hi,
I have attached a BMP screenshot of the table I would like to manipulate via a VBA macro in PowerPoint.
In the second column I have a list of attributes and in the third column (total) I have a list of the percentage of customers who value this attribute. In columns four, five, six and seven I have a list of the percentage of customers within groups 1, 2, 3, and 4 that value this attribute.
Is it possible to create a VBA script for PowerPoint that would shade the background of cells in columns 4, 5, 6 and 7 depending upon whether the number in the cell is at least 4 points higher than or 4 points lower than the number in column 3?
Essentially to take row two for example: Has Extra Long Battery Life is the attribute in column 2, 74 is the total in column 3, 73 is the number in column 4, 82 is the number in column 5, 71 is the number is column 6 and 70 is the number in column 7.
I want to shade blue cells in that row that have values at least 4 points greater than the value in column 3 of that row and shade red cells in that row that have values at least 4 points lower than the value in column 3 of that row.
So, for the Has Extra Long Battery Life row, column 5 (customer group 2) would be shaded blue since it is at least 4 points higher than the total column value (74) and column 7 (customer group 4) would be shaded red since it is at least 4 points lower than the total column value.