Conditional Formatting Ranges Increasing on Data Refresh

dappolan 

Here are a few possible reasons why your conditional formatting ranges are increasing on data refresh.

• The data you are pasting is not being pasted as values. If the data you are pasting is formulas or text, then Excel will treat the entire range of cells as dynamic, and the conditional formatting ranges will be affected accordingly. To fix this, make sure that the data you are pasting is only values.
• The conditional formatting rules are using relative references. If the conditional formatting rules are using relative references, then the ranges will be adjusted when the data is refreshed. To fix this, make sure that the conditional formatting rules are using absolute references.
• There is a bug in Excel. It is possible that there is a bug in Excel that is causing the conditional formatting ranges to increase. If you have tried the above solutions and the problem persists, then you can try updating Excel to the latest version.

To troubleshoot the issue, you can try the following steps:

1. Check the data you are pasting to make sure that it is being pasted as values.
2. Check the conditional formatting rules to make sure that they are using absolute references.
3. Update Excel to the latest version.

Here are some additional tips to help you prevent conditional formatting from changing:

• Use absolute references in your conditional formatting rules.
• Protect your worksheets so that users cannot accidentally change the conditional formatting rules.
• Use a macro to clear the conditional formatting rules before you refresh your data.

The text and the steps are the result of various AI's put together.

My answers are voluntary and without guarantee!

Hope this will help you.