 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008CheckBox to change cell color
Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet Maybe... You could use a linked cell with the checkbox. Then use Format|conditional formatting and base it on the value of that cell. If A1 is the linkedcell, you could select any other cell: Format|conditional formatting formula is: =$a$1=true and give it a nice color. > Hello Everyone > > Can I use a CheckBox to change the color of a cell ? > > Regards > Cimjet  SignatureDave Peterson Perfect, just what I need Thank you John > Maybe... > [quoted text clipped - 15 lines] >> Regards >> Cimjet Hello Again The color works well, thank you Dave but I would like to print something else than "True or False". Can I change the text to something else? Regards John > Maybe... > [quoted text clipped - 15 lines] >> Regards >> Cimjet Dave's suggestion was for the formula to be used *in Conditional Formatting* to set the colour of the cell. If you wish to write a formula in a cell to produce a text string in the cell, then you can do that as well. For example, you might use a formula =IF(A1=true,"Checkbox ticked","Not ticked") or more simply =IF(A1,"Checkbox ticked","Not ticked") . SignatureDavid Biddulph > Hello Again > The color works well, thank you Dave but I would like to print something [quoted text clipped - 21 lines] >>> Regards >>> Cimjet HI Everyone Thank you All for your support, I can make it work thanks to you guys. > Dave's suggestion was for the formula to be used *in Conditional > Formatting* to set the colour of the cell. [quoted text clipped - 28 lines] >>>> Regards >>>> Cimjet On top of what David wrote, you could put that linked cell in a column that's not part of the print range. If you have lots of these checkboxes, you may want to insert a dedicated column for all the linked cells. I like to keep the linked cell on the same row as the checkbox--but you don't have to. Then you can just hide that column and never have to worry about seeing it when you print. > Hello Again > The color works well, thank you Dave but I would like to print something [quoted text clipped - 25 lines] > > > > Dave Peterson SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.