Forum Discussion
Cell Color Based on Adjoining Cell
Is there a way to make the cell colors in G auto change based on the colors in D?
Thanks! See the attached workbook. I created 7 rules for the entire range - see Formulas > Manage Rules...
Are the colors in column D applied manually or are they the result of conditional formatting?
- They are a result of conditional formatting. Column G, totals at the bottom based on the color. I found if I use a conditional format for G based on D the SumByCellsColor doesn't work Ugggg or I have something wrong somewhere
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Column D is a drop down with conditional formatting for color based on another sheet/tab. I manage to do a conditional format to make G the same color based if D = "food lookup'... but even tho they are the same colors, the sum at the bottom ignores the color and considers it blank. Maybe I am just asking too much??
I repeat my request...
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.
