Forum Discussion
Change color in sheet1 based on cell colors in sheet2
NikolinoDE HansVogelaar Kevin Lehrbass Dear Excel Tech Experts, I have a requirement in MS Excel such that : 1) If cells C1:C10 in sheet2 are all Green then cell A1 in sheet1 should be filled ...
In your screenshots, C2:C11 are colored instead of C1:C10.
Will the cells be colored manually by the user, or do you use conditional formatting rules to color the cells?
Sorry for the confusion HansVogelaar. You are right. Please consider colored cells from C2:C11.
Cells will be colored manually by the user. The colors will be fixed and no conditional formatting will be used.