showing hidden coulmns when checking the CHECK BOX

A

AG

Hi,

i need to hide some information and to be unhidden automatically only when
someone check a box related to hidden information. example : do u require
airport pickup? if he checked the box hidden coloumn will show for FLIGHT
DETAILS. please help
 
J

Jack Schitt

One method of tackling it would be to use conditional formatting, and set
the foreground font colour to match the background font colour if the
conditions are right for it to be hidden.
 
J

Jack Schitt

Example:
Say, You want cell A1 to be hidden if cell B1 contains "Y", but otherwise to
be visible.
Select cell A1
From the menu bar select Format/Conditional Formatting
For Condition 1 change from "Cell Value is" to "Formula is" in the drop-down
box.
In the box to the right of "Formula is" enter the formula:
=B1="Y"
Now click the "Format" button, and choose font colour = white (from the
palette) or, if the background is not white, then match the background.

Just one additional tip: If the background colour is set to "no colour" then
the default background colour can be set at operating system level, ie not
within Excel. Some users prefer an off-white background to uncoloured
cells. If the foreground is set to white then it will not be hidden. In
that case it may be better to ensure that you give the background colour to
cells a particular colour, which you can then force the foreground to match.
 
Top