I am looking to add in visual ques so that when that data is presented, the highest number in a chart will be highlighted. For example, I currently have a straight table with the title "On average, how many hours a day do you drive?". I have columns that capture the date, they are; 0 hours, 1-2 hours, 2-4 hours, 5-8 hours and 9+ hours. Under each column title there is a number that represents that amount of people that answered the questionnaire. What I am trying to do is create a formula either in visual cues or elsewhere so that the column with the highest number will become highlighted when it is in fact the highest number.
I did this with questions that had only 2 columns by using visual cues and putting in the other columns formula into upper formula position. I was not able to do this with over 2 columns.