Conditional formating

Giganews Newsgroups
Subject: Conditional formating
Posted by:  Tonie Crawford (anonymo…
Date: Sat, 18 Oct 2003

I want a macro that will hide the values in a cell if
another cell is blank

Name      Cost    Paid  Balance
Jane Doe    $10.00        $10.00
John Doe            5.00    5.00
Using Excel 2000

If Name is Null or Blank Hide Balance.
If Name is not null show balance.