I need help with the formula for changing the overall status symbol based on other status symbol.
I need help with the formula in summary sheet. I need to get overall status symbol color changed based on 4 status symbols.
i.e., I have
Schedule Status as: Red
Risk Status: Green
Issue Status: Yellow
Change Status: Red
For the Overall Status, I need Green, if all status green. Yellow: 1 or more status is yellow, Red: 1 or more status is red.
In this case it should show red since, I have two red status symbols.