title: Excel conditional format entire column based on cell value
body: <p>I have a spreadsheet that has a 7000 rows. My sheet does have a header row. Column G is not supposed to have any cell with a value greater then 1000. I want to highlight red the cells with these "bad values". This I accomplished with the conditional formatting cell value greater then 1000 and applied it to G2:G10000. even though I would love to apply this G:G, so that I don't limit this to just 10,000 rows (there may be rows ith future then the current 7,000).</p>
  
  <p>My bigger issue is that to highlight that column G has a "bad" cell(s) I would lime to highlight all of column G.</p>
  
  <p>I tried using  a conditional formatting formula = $G2>1000 and applied it to G:G it only highlighted the cell. I tried = $A2>1000 and applied it to G:G, It highlighted the entire column always even when the condition wasn't met.</p>
  
  <p>What do I do?</p>