Forum Discussion
Cell Color Based on Adjoining Cell
- Apr 09, 2024
Thanks! See the attached workbook. I created 7 rules for the entire range - see Formulas > Manage Rules...
And to add to the response you've gotten from HansVogelaar , if the colors in D aren't already themselves a result of conditional formatting rules, they should be. In part, for the sake of consistency, but even more important, for the sake of coherence and meaning.
It would appear--a hypothesis on my part--that your colors in D are based on the "healthiness" of the food in question, yogurt being favored over pancakes. That being the case, I could think of several ways to create those color codes, based on a comprehensive table of foods. But it might be easiest and more transparent if in addition to the two columns there now you just added a column with a "health index" basing the colors on the values there, which could be as granular as you want. A Red=3, Yellow=2, Green=1 scale would work, for example.