Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Only Show Checked Items
I have a data input sheet that allows a user to select options with a check
box. This information is then shown with a price after the box is checked on a new quote sheet. This also displays non-checked information but without a price. I'd like the sheet to only show the description & the price of checked items. Another user here uses a Mac so including any programming is out of the question. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Only Show Checked Items
You can blank the information out by using a formula or conditional formatting.
With a formula, if sheet1 has the check boxes and sheet2 the pricing, and assuming the 1st checkbox is tied to say, a1 and the description is in say, b1 on both sheets: put this in B1 on sheet 2 =if(sheet1!a1=true,b1,"") With conditional formatting you can use "=sheet1!a1=false" without the quotes in sheet2 b1, just make the font color to be the same as the cell background. (Usually white.) Squeaky "Jesss" wrote: I have a data input sheet that allows a user to select options with a check box. This information is then shown with a price after the box is checked on a new quote sheet. This also displays non-checked information but without a price. I'd like the sheet to only show the description & the price of checked items. Another user here uses a Mac so including any programming is out of the question. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell grid lines won't show up, and have box checked | Excel Discussion (Misc queries) | |||
check box checked - then a result to show in another cell???? | New Users to Excel | |||
Can I create a checklist that changes color as items are checked? | Excel Discussion (Misc queries) | |||
re-enable a checked "don't show this again" | Excel Discussion (Misc queries) | |||
Can I insert a box on excel that can be checked and un-checked? | Excel Discussion (Misc queries) |