Mar 30 2019 12:04 AM
I am very often using the below functionnality to save time in formatting tables, benefitting of the advanced formulas functionalities.
Nevertheless, i am regularly facing the below issue.
The situation :
In this example i have the below table formatted :
I am adding a row at the botom of the table :
As you can see, the row is automatically formatted, but instead of applying the expected format, the added row is blue....this blue color is coming from a row i had into my initial table before i converted it as an "Excel formatted table"....
What i would like ?
Mar 30 2019 12:31 AM
Hi Paul,
This issue may occur if you format a range of cells (that has an existing format) as a table in a certain color scheme.
You need to clear the old format by selecting the table, then go to Home >> Font >> Fill Color >> No Fill as shown in the below screenshot.
I have answered a similar question before in this link.
Hope that helps
Mar 30 2019 08:42 AM
Hello @Haytham Amairah, thanks for your answer, i am filing a bit confused/stupid as it is so simple....never had the idea...I made the test for the color but also for a drop down list and it worked.
Thank you very much for your answer.