Forum Discussion
Solved
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...
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
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
HansVogelaar That's great thanks. It works perfectly. Thank You 🙂