Conditional formatting - hide one cell based on another?

  • Thread starter Thread starter Noozer
  • Start date Start date
N

Noozer

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!
 
Noozer

Select your cell(s) to be white-fonted. Say A1:A10

Format>Conditional Format>Formula is:

enter =C1=""

Pick a white format from the font tab and OK your way out.

Gord Dibben Excel MVP
 
set a condition of FormulaIs

set a formula of =C1=""

--

HTH

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