I have a checkbox that is linked to a certain cell. How can I get that cell
to change to a certain color when I check the box.

Thanks

Hi!

If it's a Forms Toolbar checkbox then the linked cell displays either TRUE
(when checked) or FALSE (when not checked).

Select the linked cell
Goto FormatConditional Formatting
Cell Value Is: Equal to: TRUE
Click the Format button and select the style you want

Biff

"Oppy" wrote in message
...
I have a checkbox that is linked to a certain cell. How can I get that
cell
to change to a certain color when I check the box.

Thanks

To add to that, you can set the color you want to see when FALSE (button not
checked) with ordinary cell fill formatting. The conditional formatting
overrides the regular.
--
Earl Kiosterud
www.smokeylake.com

"Biff" wrote in message
...
Hi!

If it's a Forms Toolbar checkbox then the linked cell displays either TRUE
(when checked) or FALSE (when not checked).

Select the linked cell
Goto FormatConditional Formatting
Cell Value Is: Equal to: TRUE
Click the Format button and select the style you want

Biff

"Oppy" wrote in message
...
I have a checkbox that is linked to a certain cell. How can I get that
cell
to change to a certain color when I check the box.

Thanks