Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
macquarl
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"