Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional Formatting using checkboxes
Is it possible to set up a spreadsheet that contains checkboxes that will strikethrough certain text if the box is checked? Also is there an easy way if there are two columns of checkboxes that only one in a row can be checked at a time? For instance, if you check column 1's box then colunm 2 will be unchecked, if you check column 2 then column on's will uncheck on a per row basis. -- macquarl ------------------------------------------------------------------------ macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388 View this thread: http://www.excelforum.com/showthread...hreadid=491167 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional Formatting using checkboxes
Why not just use one checkbox. Either it's checked or it isn't.
Then you could use a linked cell and check for that to be true/false in your format|conditional formatting rules. macquarl wrote: Is it possible to set up a spreadsheet that contains checkboxes that will strikethrough certain text if the box is checked? Also is there an easy way if there are two columns of checkboxes that only one in a row can be checked at a time? For instance, if you check column 1's box then colunm 2 will be unchecked, if you check column 2 then column on's will uncheck on a per row basis. -- macquarl ------------------------------------------------------------------------ macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388 View this thread: http://www.excelforum.com/showthread...hreadid=491167 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |