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?
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...
- 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?
- I can, just not sure how to attach here??
