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