Towards Conditional Format rule, we’re going to decide to try to see if the value for the line B is higher than otherwise equivalent to the complete number of weeks we would like to pick. We incorporate 1 at the conclusion of the latest algorithm (comprehend the screenshot less than) to account for day “no,” in which there isn’t any fee.
We would also like to be sure the newest anchoring is initiated properly: we need to fully point phone C8 since the we’ll always should site you to mobile (the full number of weeks). However, we simply want to anchor column B because the you to column include the newest few days amount accustomed estimate the attention and you can principal payments.
Generally, the brand new Conditional Format the brand new laws is saying if the any sort of in the column B was greater than or equal to the total number of months inside the phone C8 (together with 1 so you can take into account few days “zero”), following we should replace the font color so you’re able to light so it efficiently “hides” the costs and you will data in those muscle.