| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CheckBox to change cell color
Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CheckBox to change cell color
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. John wrote: Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CheckBox to change cell color
Perfect, just what I need
Thank you John "Dave Peterson" wrote in message ... 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. John wrote: Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CheckBox to change cell color
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 "Dave Peterson" wrote in message ... 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. John wrote: Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CheckBox to change cell color
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") . -- David Biddulph "John" wrote in message ... 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 "Dave Peterson" wrote in message ... 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. John wrote: Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CheckBox to change cell color
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. John wrote: 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 "Dave Peterson" wrote in message ... 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. John wrote: Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CheckBox to change cell color
HI Everyone
Thank you All for your support, I can make it work thanks to you guys. "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... 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") . -- David Biddulph "John" wrote in message ... 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 "Dave Peterson" wrote in message ... 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. John wrote: Hello Everyone Can I use a CheckBox to change the color of a cell ? Regards Cimjet -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| how do i change the value of a cell with a checkbox | Excel Worksheet Functions | |||
| how do I make checkbox color change when the value changes? | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
![John[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
