Checkbox and conditional formating

[sed]

How can I make a cell fill green if the checkbox is "checked" and red if not
"checked"?

 

[Satti Charvak]

Hi Sed,
Create check box, then right click on check box

select format control...go to "control " tab.

now in the cell link give the cell address where you want that red, green
colors.

now go to the cell , now from the main menu, select format -> conditional
formatting

and make 2 conditions for the value received from the check box.

 

[ShaneDevenshire]

Hi,

Once you link the cell and click it you will either see TRUE or FALSE in the
cell. Before it's click for the first time it will be blank unless you check
the Value property as Checked.

The conditional formatting you want to color the cells are:
1st condition Cell Value Is, equal to, TRUE
click the Format button and pick a color on the Patterns tab and click OK once
click the Add button
2nd condition Cell Value Is, equal to, FALSE
click the Format button and pick a color on the Patterns tab and click OK
twice

 

[ShaneDevenshire]

Hi,

One additonal comment, if you don't want to see the TRUE and FALSE, just the
colors, then choose Format, Cells, Number tab, Custom, and enter ;;; on the
Type line.