I have a table with multiple columns. I would like the numbers in the column that shows % of produce to be represented by a horizontal bar. If the percentage is 90%, for example, the horizontal bar should be long , nearly touching the left and right wall of the cell, and green. Whereas if the percentage is 20%,it should a shorter horizontal bar and should be red. I would like these bars to appear only in one column of the table, and not in the rest of the table columns, as they are not percentages.
Please help! I have struggled with this for weeks
Hi,
Thanks for the reply.
I'll also share my sample workbook. I hope you can find some hints.
In particular, the method in the second sample can be set for each column (although it is a little unwieldy).
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
