Hi!

Assume cell A2 contains the "grayed-out" text.

Cell B2 "contains" a checkbox created with the Forms toolbar.

Right click on the checkbox.
Select: Format Control
Link the checkbox to a cell. When you do this the linked cell will display
either TRUE (for checked) or FALSE (for unchecked).
Assume you link the checkbox to cell J2.

Now, select cell A2
Goto FormatConditional Formatting
Formula is: =$J$2=TRUE
Click the Format button
Font tab
Font Style: Regular
Color: Automatic (automatic is your default font color. If your default font
color IS NOT black then choose whatever color you want)
OK out

Biff

"BLUOVAL" wrote in message
...
I am trying to create a list (3 columns) with check boxes. I have my text
color grayed out. When i check the box, I want the text to turn black.
When
I uncheck the box I want the text in that cell to go back to gray. Please
help.................!

Jim