Checkbox and conditional formating
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 a
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
--
Thanks,
Shane Devenshire
"Satti Charvak" wrote:
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
|