Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

enter image description here

However once I close and re-open, it looks like this:

enter image description here

When I went into the parameters, I saw Excel is actually changing my range from =$A$4:$N$119 to =$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.

share|improve this question
Do you consider VBA solution? – lowak Apr 16 '14 at 6:09
I did - The spreadsheet is already using VBA to bring up a pop-up, then do a refresh and then remove certain rows based on values, but with my limited VBA knowledge I wasn't 100% sure how to apply conditional formatting inside all of this – Lisa Apr 16 '14 at 6:48
up vote 0 down vote accepted

Couldn't really find an answer for this but got a workaround - pivoted the query results instead and just applied conditional formatting on the pivot.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.