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
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
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
AutoIan 'Can you provide more detailed information about the layout of your worksheet?
Perhaps attach a sample workbook.
HansVogelaar i have attached an example of the sheet. Thanks Ian
See the attached version. I changed the month names to dates (in 2022), formatted as mmmm to display the full month name.
