Forum Discussion
Auto populate the multiple rows if the condition is met
Hi everyone,
I'm currently working on a recruitment forecasting file.
The idea is when someone enters 1 to any cell, excel should populate the possible timeline for the recruitment plan.
Example:
If July 2023 is the possible start date
April, May, and June 2023 are the training period
March is the notice period
February is interviews
The job ad posting is in January
How can I achieve this?
https://docs.google.com/spreadsheets/d/1g1Bt537g1o-4DXzFXywaELGkKPB0DUur/edit?usp=sharing&ouid=117514779425345009358&rtpof=true&sd=true and thank you so much for the support!
Hi Egemen
Dates (and not Text values like Dec, Jan...) must be enterred in row 10. You can Custom format them to only display short month names if you want
All Cond. Format. rules, but for Commencement, done with https://support.microsoft.com/en-us/office/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5 & https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 functions - see attached file
7 Replies
See the attached version.
- Thank you so much Hans!
Hi Egemen
Dates (and not Text values like Dec, Jan...) must be enterred in row 10. You can Custom format them to only display short month names if you want
All Cond. Format. rules, but for Commencement, done with https://support.microsoft.com/en-us/office/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5 & https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 functions - see attached file
- Thank you so much! This was exactly the solution i was looking for!
Glad I could help & Thanks for providing feedback
Just had a look HansVogelaar's option, it's much easier ==> Liked it
