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?