Excel conditional format entire column based on cell value

[zfeld75]

​

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).

My bigger issue is that to highlight that column G has a "bad" cell(s) I would lime to highlight all of column G.
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.

What do I do?

 

[Joe4]

I tried = $A2>1000 and applied it to G:G

That will check EVERY row in column A, and if any exceed 1000, the whole column G will be highlighted.
If you only want to check cell A2, you need to lock the row reference too, i.e.

[COLOR=#242729][FONT=Arial] =$A[/FONT][/COLOR][COLOR=#ff0000][FONT=Arial][B]$[/B][/FONT][/COLOR][COLOR=#242729][FONT=Arial]2>1000[/FONT][/COLOR]