Conditional Formatting and Drop Box

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a spreadsheet that I have been working on for a
bit. I have many formulas that are integral to the sheet,
but do not want them to show when I print out a copy of
the sheet.

I have a drop box established that has an on and an off
drop choice. I want to set up a conditional formatting
where all the numbers and the boxes I have surrounding
those numbers disappear.

I think the easiest way to do this is to just set the
numbers to the color white. This effectively makes them
disappear! I want to make it so the boxes go away too.
How can I set up the conditional formating in the way
that I want to. I have Office XP. I thought I did it
right, but it seems to tell me that I had chosen too many
cell to format. I thought that was okay.

Advice appreciated!

Also, go see Kill Bill, its pretty crazy!

Michael
 
Michael,

The conditional formatting is easy enough. Assuming the value from the
drop-down (not sure whether it is data validation, controls, or forms, but
the value can always be taken from a cell) is in cell A1, select all of your
conditional cells, again assume the first is B1, go into CF, select Formula
Is and add the formula
=B1=$A$1
and then set the font to white as you suggest.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I still cannot seem to do it correctly. I have read on
the topic of conditional formatting. You can have several
values and then a relationship operator (a switch).

I may need simple step by step instructions (not too long
though!) to do this correctly!

My switch is D8 in a box. In the cell to the left, it
says Cost Drivers. In the box (D8) are the 2 options of
Show and Hide. The drivers are all showing right now.

A simple set of drivers that I want to remove are in cell
range (D57:D60). I want to set up a conditioning format
where the outline box is removed and the text color is
set to white when I click the switch to say Hide. This is
so I can print it out and show it to clients as simply
and without clutter.
 
Back
Top