"JCanyoneer" wrote in message ...
This is probably simple but I cannot figure out the syntax. I have a few
checkboxes on a sheet that I would like to have run a macro that would bold
or unbold based on the value of the checkbox or its cell reference. I'm not
sure if there is a better way than a macro or not.

You can use a macro, sure, or you can use Excel's built-in conditional
formatting.

As an example, create a new worksheet and put some True/False values
in column D.

Select column D, then go to Format | Conditional Formatting.

For Condition 1, fill in the following information:

First dropbox: "Formula Is"
Text entry box: "=$D1=True"

Click the Format button, select Bold. Click OK, click OK. That should
do it.

(These instructions are for Excel 2002, but it should be the same for
XP)

Note that you can only have three conditional formats in a worksheet
at one time, so if you have something more complicated you may wish to
use a macro.