hi Paul,
Please refer to the attached sheet.
there are four scenarios; all of them have inflation of 3%, however there is differnt earning rate (this is net earning rate, after taxes), but not the real return rate (which factors in the inflation).
I have also used the conditional formatting and entered the formula (min) as per your suggestion. That was great help.
.
Do you think it would be possible to enter - retirement age in input sheet cell "b24" and make certain rows hidden or invisible in sheets "scenario1,scenario2,3 and 4. I do not want in the entire workbook since there can be many more sheet I will enter.
What do you think?