Checkbox!!

O

Oppy

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
 
B

Biff

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 Format>Conditional Formatting
Cell Value Is: Equal to: TRUE
Click the Format button and select the style you want

Biff
 
E

Earl Kiosterud

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.
 
Top