Using conditional formatting to "blank" cells
 

Hi,

I've got a spreadsheet with some check boxes in it. When one of the
checkboxes is "checked", I want some new cells to appear that wouldn't
be visible if the checkbox is left "unchecked".

To achieve this, I've used conditional formatting to make the cells'
background colour black if the checkbox is unchecked, thus "hiding"
them. When the box is checked, the appropriate text appears. However, I
want the user to be able to input data into a couple of the boxes, but
obviously there is an IF formula in these boxes at present, and if data
is entered, the IF formula will be erased.

Is there any way around this?

Sorry if my explanation's a little complicated.

Thanks.


--
terryc
------------------------------------------------------------------------
terryc's Profile: http://www.excelforum.com/member.php...o&userid=35796
View this thread: http://www.excelforum.com/showthread...hreadid=555675

Using conditional formatting to "blank" cells
 

What formula is in the cell? Conditional formatting formulae are not in the
cells, they are separate.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"terryc" wrote in
message ...

Hi,

I've got a spreadsheet with some check boxes in it. When one of the
checkboxes is "checked", I want some new cells to appear that wouldn't
be visible if the checkbox is left "unchecked".

To achieve this, I've used conditional formatting to make the cells'
background colour black if the checkbox is unchecked, thus "hiding"
them. When the box is checked, the appropriate text appears. However, I
want the user to be able to input data into a couple of the boxes, but
obviously there is an IF formula in these boxes at present, and if data
is entered, the IF formula will be erased.

Is there any way around this?

Sorry if my explanation's a little complicated.

Thanks.


--
terryc
------------------------------------------------------------------------
terryc's Profile:
http://www.excelforum.com/member.php...o&userid=35796
View this thread: http://www.excelforum.com/showthread...hreadid=555675