EXCEL FORMS CHECKBOX
 

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

EXCEL FORMS CHECKBOX
 

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

EXCEL FORMS CHECKBOX
 

Biff,
Thanks for replying so fast. I guess I didn't make myself clear enough. I
have a column for a check box and adjacent to that is a column of grayed out
text. I only want the text color to change and not the text. When I check a
check box, I need the color of the corresponding text to turn black.
Right now the grayed out text is being changed to either "TRUE" in black or
"FALSE" in gray.

I also need to copy this throughout the page.

Thanks in advance for your help.

Jim

"Biff" wrote:

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

EXCEL FORMS CHECKBOX
 

Hi!

It sounds like you're linking the checkbox to the cells that contain the
text. That's not what I wrote in my reply!!!!

You have to link the checkbox to a different cell and then base the
conditional formatting on that cell being TRUE.

Let me try it again:

If cell A2 contains the text, cell B2 contains the checkbox, link the
checkbox to some cell other than A2, say, J2.

Biff

"BLUOVAL" wrote in message
...
Biff,
Thanks for replying so fast. I guess I didn't make myself clear enough.
I
have a column for a check box and adjacent to that is a column of grayed
out
text. I only want the text color to change and not the text. When I
check a
check box, I need the color of the corresponding text to turn black.
Right now the grayed out text is being changed to either "TRUE" in black
or
"FALSE" in gray.

I also need to copy this throughout the page.

Thanks in advance for your help.

Jim

"Biff" wrote:

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