Oops, I see you said CF. Doh!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SmartyPants" wrote in message
ups.com...
I have two check boxes.

Depending on which is checked, I have a cell that reads either 1 or 2.

Right now, I have conditional formatting set up to "Black Out" sections
of the workbook, depending on which box is checked.

Is there any way to just hide these rows or columns?

The blacked out thing looks kinda tacky.

Example: Cell=1, then hide rows 2,3,and 4. Cell=2, then hide rows 8, 9,
and 10.

Something like that.