Forum Discussion
Solved
Excel formula
Hi All,
Query 1-
I need a formula where if I change the value in a cell the value of the other cell should change
Eg - If I change the value of cell 1 to 6 PM then the cell 2 value should change to 8 AM automatically and If I change the value of cell 1 to 8 AM then the cell 2 value should change to 6 PM automatically and vice versa for Cell 2 as well
Note- the values in cells will either be 6 PM or 8 AM
Currently, I've used data validation to create a drop-down list where I can select either be 6 PM or 8 AM manually for both cells
| Time | (Cell 1)6 PM | (Cell 2)8 AM |
Query 2 -
If I select Night from C0's drop-down list then the value of C1 and C2 should automatically change to 6 PM and 8 AM respectively and If Day is selected from C0's drop-down list then the value of C1 and C2 should automatically change to 8 AM and 6 PM respectively
| (C0)Night /Day | Hours (EST) | (C1) 6:00 PM | (C2)8:00 AM |
Note - If we can resolve Query 2 then no need for resolving Query 1.
Regards,
Arbaz Q
AQureshi1709 See attached file for solutions to both queries.
AQureshi1709 See attached file for solutions to both queries.
Riny_van_Eekelen I have another Query now! I am sharing the original sheet which I am working on.
This time I need assistance working with Job Status and Status-
If you see I have the Job Status List as Completed, Failed, Dependency, and Running along with the color assigned to each of them
What I usually do is manually change the Status color as per the Job-status list.
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.
Priority - Red, Orange, Yellow, Green
Do we have any formula for this?
AQureshi1709 Sorry, but I don't understand your last question.
Riny_van_Eekelen Thank you soo much!!!
The only issue I am facing is that my Data i.e Day, Night, 6 PM & 8 AM is on different sheet2 of the same file.
PFA, added sheet 2 on the same file.
AQureshi1709 See attached. I chose to use named ranges for the two relevant areas. Then it doesn't matter where in the workbook they are.
