Ok, say the value you want to watch is in B1, so you select row 1 or more, do the "conditional format - new rule - use a formula..." thing and enter the formula

=$B1>0

and select the format you want it to be.

hth