Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox and conditional formating
How can I make a cell fill green if the checkbox is "checked" and red if not
"checked"? -- sss |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox and conditional formating
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox and conditional formating
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. -- Thanks, Shane Devenshire "sed" wrote: How can I make a cell fill green if the checkbox is "checked" and red if not "checked"? -- sss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
using a checkbox for a conditional function | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Worksheet Functions | |||
Conditional Formating with Checkbox | Excel Worksheet Functions |