Conditional formatting - hide one cell based on another?

Hi!

I'd like to hide the contents of a cell if another cell on that row is
empty.

I thought I'd be able to use conditional formatting, but I don't see how to
reference another cell. I set the page background to be white, the text to
be black and the was going to use conditional formating to say "if the cell
in column three is blank, set the text color in this cell (column one) to
white".

How can I accomplish this?

Thanks!

Hi!

An example:

A3 holds a value.
B3 has conditional formatting using

Formula is ..... =$A$320

Format set as text white.....

When A3 is 20, B3 will have white text.

Alf


---
Message posted from http://www.ExcelForum.com/

Hi

In the cell in column 1 (say A3), you can have a conditional format with the
formula =isblank(c3) and set the font to "white"

Should work.

André


"Noozer" wrote in message
news:e2OVc.176554$gE.117022@pd7tw3no...
Hi!

I'd like to hide the contents of a cell if another cell on that row is
empty.

I thought I'd be able to use conditional formatting, but I don't see how
to
reference another cell. I set the page background to be white, the text to
be black and the was going to use conditional formating to say "if the
cell
in column three is blank, set the text color in this cell (column one) to
white".

How can I accomplish this?

Thanks!