Hello,
I'm using Excel to analyse some tables of results from a survey.
It's a large data set and I'm looking to comment on where there are differences between certain groups. Instead of having to scroll through all of the data manually I was hoping there would be a formula I could use to quickly highlight any points of interest.
Using the example attached
Looking at the first question about the taste of apples changing, I want to see if there are any differences between the groups of occupations. In row 8, we can see 16% of group C (cell E8) said it had improved compared to 33% in Group E (cell G8).
Is there a way to highlight where there are substantial differences between the figures in each row in each table?
I've become stuck because I've only done simple conditional formatting before with a reference cell. This would need to be able to compare all of the values with all of the other values in that row of each table, and highlight if there is say a 10% difference between any of them.
My hope would be I could then see a highlight in the spreadsheet as an indication to investigate if it's relevant or not.
I did wonder about the outlier function but there are lots of questions (taste of oranges) and then lots of categories (occupation, pay band etc) so calculating the mean, quartiles etc for each set is then more work than just reading through. Plus I'm not sure it works if I'm comparing discrete groups to one another.
Thanks so much for any advice
Bookmarks