Nov 25 2022 05:19 AM
Greetings!
I would like to ask your suggestion on what formula should I use in conditional formatting to show number of rows based on the number I input in data validation cell. Kindly refer below for reference:
Nov 25 2022 05:54 AM
I don't understand your numbers (the M Amort is for 0% interest), but perhaps you can use the attached demo.
Nov 25 2022 06:03 AM
Nov 25 2022 01:15 PM
Perhaps this recent discussion will be helpful.
Nov 25 2022 01:42 PM
Assuming you have Excel 365 and can use SEQUENCE as @Hans Vogelaar suggests, the conditional formatting can be based on the month number
= ISNUMBER($A6)