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.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"sed" wrote:

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