I have conditional formatting on Columns A to N. Columns F to N are updated every time I open the spreadsheet as it pulls info from a SQL script. The problem I'm having is the following:
My conditional formatting is meant to look like this:
However once I close and re-open, it looks like this:
When I went into the parameters, I saw Excel is actually changing my range from
=$A$4:$E$119 after the query has run. Is there any way to get Conditional Formatting to apply its rules after a query has been run? I've tried searching online for this but I'm not having much luck.