Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
True/False Checkbox
Hey All,
This may be a really simple question to answer but I can't figure it out so thought someone might be able to help. I have inserted a checkbox on one sheet which is linked to a cell on another sheet. This is fine. When I check the box it comes up with true and un-checked false as expected. My question: is there any way to make it say "Complete" for true and "incomplete" for false? Also is there anyway to change the cell background colour for each value? Any ideas anyone? Please bear in mind that I'm still finding my way around the more complex functions of excel. Feel free to drop me an email: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
Marking a range True or False based on a single Checkbox | Excel Programming | |||
I need to create a simple checkbox that has true false outputs | Excel Discussion (Misc queries) | |||
checkbox true/false label | Excel Programming | |||
Checkbox toggle true/false | Excel Programming |