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 f...
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.
- I'll try. Thank you very much.