Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using checkbox to change cell color
Hello. I am very new to excel. At work, I was tasked with creating a checklist that when you click the check box, the cell turns green. I have absolutely NO clue how to do this. If someone could explain this to me in detail (again, I don't understand excel jargon) I would greatly appreciate it.
Heres an example: Cell A2-E2 states: Account for all non-essential personnel. The check box is in cell A2. When I click the check box, I would like the cells where the text is (A2-E2) to highlight green. I have approximately 50 checkboxes in my spreadsheet and I'm assuming if I learn how to do the first one, the rest will be the same with the exception of changing the cell numbers. Thanks in advance!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
CheckBox to change cell color | New Users to Excel | |||
Checkbox - Change color of label when clicked | Excel Programming | |||
how do i change the value of a cell with a checkbox | Excel Worksheet Functions | |||
how do I make checkbox color change when the value changes? | Excel Discussion (Misc queries) |