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?