Forum Discussion
Conditional Formatting Formula
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:
Assuming you have Excel 365 and can use SEQUENCE as HansVogelaar suggests, the conditional formatting can be based on the month number
= ISNUMBER($A6)- Okay. Thank you very much.
I don't understand your numbers (the M Amort is for 0% interest), but perhaps you can use the attached demo.
- My concern is the rows that when I entered number in data validation list/cell that number will be reflected through rows. Let say, if I put 9 in data validation list, the number of rows will also be 9. The amounts in the data are for demonstration only. Thank you.
Perhaps this recent discussion will be helpful.
