Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox
Is is possible to set up a formula that if a checkbox is checked it will
highlight a particular field? And how do you bold a checkbox/mark? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox
The checkbox should have a link cell, then conditional formatting to check
that cell and highlight whichever field based on what is in the linked cell. ie. TRUE or FALSE will be what is in the link cell. Right click the checkbox and go to Format Control, then enter the cell link that you want to use to reference in your conditional format. "AlliSun" wrote: Is is possible to set up a formula that if a checkbox is checked it will highlight a particular field? And how do you bold a checkbox/mark? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox
hi
formulas return values, they can not perform actions like "highlight a particular field". but if you are talking about a activeX contol on the sheet, you can put code in the sheet to high light a cell or range of cells. in design mode, right click the checkbox then click view code. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("B5").Interior.ColorIndex = 41 Else Range("B5").Interior.ColorIndex = xlNone End If End Sub for a range of cells.... Range("B5:B15").Interior.ColorIndex = 41 see this site for color index numbers http://www.mvps.org/dmcritchie/excel/colors.htm regards FSt1 "AlliSun" wrote: Is is possible to set up a formula that if a checkbox is checked it will highlight a particular field? And how do you bold a checkbox/mark? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbox | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Checkbox | New Users to Excel | |||
Checkbox help | Excel Discussion (Misc queries) | |||
checkbox | Excel Worksheet Functions |