Using conditional formatting to "blank" cells

[terryc]

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.

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>