LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Exclamation 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox to change background color, font color and remove/ add bo Sara Excel Discussion (Misc queries) 2 May 1st 23 11:43 AM
CheckBox to change cell color John[_13_] New Users to Excel 6 January 18th 08 03:42 PM
Checkbox - Change color of label when clicked Tammy H Excel Programming 2 March 8th 07 02:00 AM
how do i change the value of a cell with a checkbox Rollie13 Excel Worksheet Functions 3 November 24th 06 11:47 PM
how do I make checkbox color change when the value changes? Lynda Excel Discussion (Misc queries) 2 January 27th 06 12:12 PM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"