default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 180
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hello!
Is there a way to automatically add a comment to a cell within a certain range if the cell has content?
Here is an example of what I mean...(I cant share the actual content, so hopefully this example explains my idea)
I set up a calendar to keep track of food that is eaten.
If a person eats breakfast, then the Breakfast box for that day is checked and a comment is added to that cell so that the user may input what was eaten for breakfast.
In this table, for example, the person ate Breakfast on Monday (as shown by the non-blank cell). In the Monday Breakfast cell I would want a New Comment to be added so that the user may input the foods that were eaten. I do not want comments to be added to the cell if they are blank (Monday Lunch for example). I would only want these behaviors to take place in cells B2:H4 (in the example shown).
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sun
[/TD]
[TD="align: center"]Mon
[/TD]
[TD="align: center"]Tue
[/TD]
[TD="align: center"]Wed[/TD]
[TD="align: center"]Thu
[/TD]
[TD="align: center"]Fri
[/TD]
[TD="align: center"]Sat
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: right"]Breakfast
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: right"]Lunch
[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: right"]Dinner
[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x
[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
I hope that makes sense.
Thanks in advance for your help and let me know if I need to clarify anything.
Is there a way to automatically add a comment to a cell within a certain range if the cell has content?
Here is an example of what I mean...(I cant share the actual content, so hopefully this example explains my idea)
I set up a calendar to keep track of food that is eaten.
If a person eats breakfast, then the Breakfast box for that day is checked and a comment is added to that cell so that the user may input what was eaten for breakfast.
In this table, for example, the person ate Breakfast on Monday (as shown by the non-blank cell). In the Monday Breakfast cell I would want a New Comment to be added so that the user may input the foods that were eaten. I do not want comments to be added to the cell if they are blank (Monday Lunch for example). I would only want these behaviors to take place in cells B2:H4 (in the example shown).
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sun
[/TD]
[TD="align: center"]Mon
[/TD]
[TD="align: center"]Tue
[/TD]
[TD="align: center"]Wed[/TD]
[TD="align: center"]Thu
[/TD]
[TD="align: center"]Fri
[/TD]
[TD="align: center"]Sat
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: right"]Breakfast
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: right"]Lunch
[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: right"]Dinner
[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x
[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
I hope that makes sense.
Thanks in advance for your help and let me know if I need to clarify anything.
Last edited: