Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 17th 14, 12:45 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2014
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!!

  #2   Report Post  
Old April 17th 14, 01:16 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,693
Default Using checkbox to change cell color

Hi,

Am Thu, 17 Apr 2014 12:45:46 +0100 schrieb Janellec1986:

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.


I would not put 50 checkboxes into a sheet. If you filter the data the
checkboxes don't stay in place.
Make a helper column and format as "Webdings" and write a "a" in it or
delete it. You can highlight the cells then with Conditional Fotmatting
Please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "HighlightCells".
Rightclick and download the file to see the formula in the Conditional
Formatting and how this works.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #3   Report Post  
Old April 18th 14, 03:37 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 2
Default

Nothing needs to be filtered. Its one page of "to-do" items, if you will. My boss wants a checklist where if you click the box, the task turns green (complete). I don't understand the helper column at all since, as I mentioned in my original post, I am very new to this. A breakdown or step-by-step would be extremely helpful...

Quote:
Originally Posted by Claus Busch View Post
Hi,

Am Thu, 17 Apr 2014 12:45:46 +0100 schrieb Janellec1986:

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.


I would not put 50 checkboxes into a sheet. If you filter the data the
checkboxes don't stay in place.
Make a helper column and format as "Webdings" and write a "a" in it or
delete it. You can highlight the cells then with Conditional Fotmatting
Please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "HighlightCells".
Rightclick and download the file to see the formula in the Conditional
Formatting and how this works.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


Reply
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) 1 November 11th 08 08:17 PM
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:47 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017