Forum Discussion
Cell formatting based on other cells content
I have a tracker that I am using for observations.
I would like to be able to auto populate the next observation box based on the grade of the current observation (Drop down) and the key (Green =+6 months, Amber=+ 3 months, Red = +1 month)
| Month Last Observed | Current Grade | TLC | Next Obervation Due |
| 02/01/2022 | RED |
I'm sure that i have done it before but i can't remember how.
Thanks, Ian
Let's say the date last observed is in A2, and the current grade in B2
In D2:
=EDATE(A2,IF(B2="RED",1,IF(B2="AMBER",3,IF(B2="GREEN",6))))
or
=EDATE(A2,IFS(B2="RED",1,B2="AMBER",3,B2="GREEN",6))
This can be filled down
14 Replies
Let's say the date last observed is in A2, and the current grade in B2
In D2:
=EDATE(A2,IF(B2="RED",1,IF(B2="AMBER",3,IF(B2="GREEN",6))))
or
=EDATE(A2,IFS(B2="RED",1,B2="AMBER",3,B2="GREEN",6))
This can be filled down
- Thanks for you help with this, can i ask you for some help with my next problem.
i need to add up the months in the next observation column, to show how many are due each month. i have tried but i keep getting errors.
Thanks for your help HansVogelaar That's great thanks. It works perfectly. Thank You 🙂
