MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by jeannine on January 18, 2002 9:05 AM


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

Posted by on January 18, 2002 11:34 AM