Conditional formating

  • Thread starter Thread starter Tonie Crawford
  • Start date Start date
T

Tonie Crawford

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
5.00
Using Excel 2000

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

Tonie
 
Torie,

Use Format>Conditional Formatting and set the dont colour to white. The
formula would be
=$A1=""

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top