Forum Discussion
Egemen
Oct 07, 2022Copper Contributor
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. Exam...
- Oct 07, 2022
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
HansVogelaar
Oct 07, 2022MVP
See the attached version.
- EgemenOct 07, 2022Copper ContributorThank you so much Hans!