Forum Discussion

Copper Contributor

Apr 09, 2024

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?

Formulas and Functions

HansVogelaar
Apr 09, 2024
CLGill200

Thanks! See the attached workbook. I created 7 rules for the entire range - see Formulas > Manage Rules...
Menu to share.xlsm706 KB

Copper Contributor

https://1drv.ms/x/s!AtHH0rDy5pGqzY0rhs8sIYECjJqFUA?e=auxS8o

MVP

Apr 09, 2024

Thanks! See the attached workbook. I created 7 rules for the entire range - see Formulas > Manage Rules...

Menu to share.xlsm706 KB

Share

Resources