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
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 |