Forum Discussion
Excel formula
AQureshi1709 See attached file for solutions to both queries.
Okay!
On 1) you didn't set up the named ranges as I suggested. Have done that now.
On 2) you want the color of cell H6 to change automatically, based on the Job Status in Column F. In your example, the latter has all four of the possible status filled in. What would trigger the color for H6?
First of all, really appreciate you taking the time to address these silly mistakes on this platform.
1) Thank you, Sir! I've recently started working with Excel for a few weeks.
I didn't pay attention to Named Ranges which you mentioned earlier before.
I did some research and was able to figure out what you actually meant by Named Ranges
I tried again and it worked.
2) Currently we do everything manually - Eg. changing Job status in column F and depending on that we change H6 color
If in column F all job status is green, we manually change H6 to Green via Dropdown.
If in column F any one job status is Red/Failed others can be Green/Orange/Yellow, we change H6 to Red
if there is any 1 Red job (Rest can be Yellow/Green/Orange) in the list then automatically mark the Status as Red.
if there is any 1 Orange job (Rest can be Yellow/Green/No Red) in the list then automatically mark the Status as Orange.
if there is any 1 Yellow job (Rest can be No Red/Green/ No Orange) in the list then automatically mark the Status as Yellow.
if there is any 1 Green job (Rest can be No Red/No Yellow/ No Orange) in the list then automatically mark the Status as Green.
If possible can we get on a zoom call so that I can explain more clearly - I will be available from 3 - 7 PM EST.