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??
