Hi. This question refers to the amortization calculator discussed in earlier questions I submitted. And I have attached a fresh copy of the spreadsheet.
The issue is this: I have added conditional formatting so that when the loan balance equals zero ($K24=0), that everything below ($B$25:$L$2023) will be white. One formula changes the text to white and the other formula changes the fill to white. This works quite nicely for most circumstances; however, there are a few idiosyncratic circumstances where the formatting refuses to apply.
I have found that when I enter 15 or 27 into the Loan Payments field, that the formatting fails to work and will display 0s and the contents of the other columns all the way down to row 2023. One other consequence of this is that the "Actual No. Pmts" field under "Results" in the upper right shows 2000.
And my question: Do you have any idea why the conditional formatting fails to apply when these few numbers (15, 27, 41,47 for example) are entered as number of yearly payments?