if

Help,

I have a worksheet with in order an actual column, forecast column and a variance column. The middle column "forecast" has a forecasted value, the actual will not until it is manually put in. Can the variance cell be hidden or conditioned to not show a value until an acutal value is inserted? I already have a conditional formula in the variance cell conditioning less than "0" (red) and more than "0" (black).