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

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