Into the Conditional Formatting laws, we’re going to sample to see if the value within the line B was more than or comparable to the number of months we need to get a hold of. We create one after the new algorithm (comprehend the screenshot less than) so you can make up week “zero,” where there’s no percentage.
We would also like to be sure the fresh anchoring is established properly: we wish to fully point cell C8 since we’ll always want to site you to cellphone (the level of days). not, i simply want to anchor column B since the one column includes the latest week amount regularly calculate the eye and dominant payments.
Generally, the fresh new Conditional Format the fresh signal says when the any sort of in the column B was greater than or equivalent to the full level of months inside cell C8 (along with 1 so you can take into account day “zero”), next we want to replace the font color to help you white so which effortlessly “hides” the costs and you can data when it comes to those cells. (more…)