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...

excel

Formulas and Functions

Lorenzo
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 EDATE & XLOOKUP functions - see attached file
Forecasting.xlsx28 KB

Forum Discussion

Auto populate the multiple rows if the condition is met