Highlight Row if Value in Column is above 0 - Google Spreadsheet

Question

I am trying to get a Google spreadsheet to automatically highlight all rows in a spreadsheet where the value in a particular column is above 0. I have looked for a few solutions but haven't got it to work.

I have got various metrics in the columns, so say I want to highlight all rows, in which column "I" has a value of more than zero.

Can someone help me with this?

Answer 1

On the conditional formatting page choose "Custom formula is" from the list of options available and then in the text field type:

=$I:$I>0

Select your formatting options and then in the range field type the range. For example:

A2:Z100