I have a worksheet that I use as an Agenda. (picture attached below)
The column that has the Agenda Item 1, Agenda Item 2, etc... is actually a formula that is grabbing data from other areas of my workbook. As you can see I currently just have a rectangle drawn in the column labeled complete. Since the formula used to create the agenda items may or may not produce a value for the row what I would like to do is not have the rectangle appear if the value of the cell to the left of it is blank.
It was also suggested that I could use the checkbox object and if I did that it could populate the cell to the right with the date that the check box was activated. That would be helpful as well but I would still only want the checkbox object to appear if there were something in the Areas of Discussion Column.
I'm thinking it is going to be VBA of some kind that will need to accomplish this. Anyone have any code suggestions?
The picture of what my spreadsheet looks like... agenda.jpg
Bookmarks