Skip Condition Formatting If Sum of Column Equals Zero

Hey Everyone,

I'm running into a problem with trying to stop conditional formatting if there are no values in a column. If even one cell in the column has a value, I need the conditional formatting applied to all cells(blanks included). The column in question is column V.

Original formula: =VLOOKUP(A5,'NF Distribution'!$A:$U,19,0)<>V5

Modified formula: =IF(SUM(V5:V494)>0,VLOOKUP(A5,'NF Distribution'!$A:$U,19,0)<>V5,"")

Attached is my excel file.

Any help you could give me would be appreciated!

Thanks

Ace,

It works, but not completely. If I add a value to Cell V29, it will only turn on the conditional formatting to all the cells above it(V5:V29). It completely ignores V30:V494, even though there are cells that should be highlighted red.

Ace,

This is exactly what I was looking for! Thank you so much!