Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .