hello,
I created a table with an external data link (sql) to the Excel sheet.
According to the information in the table I have defined the conditional formatting to many fields.
I fixed the implementation targets of the conditional format.
My problem is;
Every time I refresh the data sheet that I created in Excel, the conditional formatting that I create is changed in both the rule and application areas.
When I update the data, the conditional formatting rules and application areas are corrupted.
When I look at the settings in the data link and the conditional formatting field, I have not seen an option to fix this problem.
When I called Microsoft Turkey office, on the phone and directed staff could not help me in this field.
you can help me with what I should do.
