I'm trying to format cell D3 in the attached example, based on cells in the worksheet 1. The logic is simple, if cells 1!F6:N7 are all green Overview!D3 is green, if any cell in 1!F6N7 is yellow, Overview!D3 is yellow, and if any cell in 1!F6N7 is red, Overview!D3 is red.
I've looked at xlDynamic
but can't copy/paste the code, and Pearson's solution
but couldn't get anything other the 0 back.
Any help is appreciated!