Forum Discussion
Percentage of 2 colors from a column to a cell
Riny_van_Eekelen thanks for the reply my friend. It would be almost that! I need cell D57 to show me only the % of the most repeated color in column D2:D46. I will send you a picture for you to see! Hope you can help me, thanks!
help_please360 You'll need the two cells that calculate the % for each color, but you can hide them somewhere. D57 will then contain a formula that takes the maximum of the two. Use conditional formatting to color D57 reg or green. See attached.
Riny_van_Eekelen thank you my friend, it worked! I just need now that this result has a color scale for the percentage of red and green. I tried to make this color scale in a few ways but ended up replacing the main rule that takes the cell with the highest %.. could you tell me how I can put this coloring rule in the same image below ? Thank you for your help
help_please360 I feel you are expanding the problem step-by-step without giving the whole picture from the beginning. And you don't show the context in which you want to apply the formatting. Just some small screenshots which don't reveal the overall issue. Nevertheless, perhaps the attached file holds the key to finding whatever formatting solution you are needing. If not, I strongly recommend you to clarify your needs.
Riny_van_Eekelen Sorry for the lack of information or for some grammatical errors in my writing. That would be almost what you send me, I need the result of the highest % on the D57, but with a red or green color scale. Example: in D57, if the highest % is red, that percentage appears in red with scale and if the highest % is green, that percentage appears in green with scale in D57. If I didn't explain it very well, I apologize and I'll try to explain it better! Follow image for better interpretation. Thank you for your help