Meifong has attended:
Excel Advanced - Formulas & Functions course
Conditonal formating - last row
Hi there :)
I have a excel file for loan amortisation.
Inside, depending of the assumption key in (number of periods to amortised, which is linked to the number of row), the number of row in the amortisation table will increase or decrease automatically, and the table will also color the first row till the "adjusted" last row.
How can I do such request by my self on a new excel spreadsheet, in general?
Thank you :)
Mf
RE: Conditonal formating - last row
Hi Meifong
Thanks for your question!
As far as I can understand here, you are looking to create dynamic conditional formatting that moves as more/less data is added.
First, turn your data into a dynamic range by going to the Home ribbon>Styles section>Format as Table. Try using a design with no fill colours, as this can override your conditional formatting.
Now add your conditional formatting. Because the data is now a dynamic range, if more data changes and the row number changes, the conditional formatting will move accordingly.
Hope this answers your question, let us know if you have any further issues.
Kind Regards,
Sarah
Excel Trainer
RE: Conditonal formating - last row
Hi Meifong
Thanks for your question!
As far as I can understand here, you are looking to create dynamic conditional formatting that moves as more/less data is added.
First, turn your data into a dynamic range by going to the Home ribbon>Styles section>Format as Table. Try using a design with no fill colours, as this can override your conditional formatting.
Now add your conditional formatting. Because the data is now a dynamic range, if more data changes and the row number changes, the conditional formatting will move accordingly.
Hope this answers your question, let us know if you have any further issues.
Kind Regards,
Sarah
Excel Trainer
