texaslonghorn
New member
- Joined
- May 30, 2011
- Messages
- 8
- Reaction score
- 0
- Points
- 0
Hi. I am running Excel 11 on my Mac and have a couple things I think are easy for experienced folks.
First, I have lots of cells across several worksheets in a file that have both an answer selection pop up menu (like Y or N) and conditional formatting based on the answer selected. Right now, when I make a change to the formatting or answer list, I have to manually modify each cell in the workbook which takes lots of time. Is there a way to set up a single "template" cell or something that can then be automatically copied or applied to all the cells I need? Or is this manual method really my only option?
Second - and this is really stoopid - I have a little yellow box that pops up (not the comment box cuz I don't have the little triangle in the upper right corner of the cell) when you mouse over the cell. Yes, I set it up but I can't recall what that box is called. I want to edit it and for the life of me I can't remember the phrase to search for in Help to remember how I created it or how to edit it. Can someone remind me? Thanks.
First, I have lots of cells across several worksheets in a file that have both an answer selection pop up menu (like Y or N) and conditional formatting based on the answer selected. Right now, when I make a change to the formatting or answer list, I have to manually modify each cell in the workbook which takes lots of time. Is there a way to set up a single "template" cell or something that can then be automatically copied or applied to all the cells I need? Or is this manual method really my only option?
Second - and this is really stoopid - I have a little yellow box that pops up (not the comment box cuz I don't have the little triangle in the upper right corner of the cell) when you mouse over the cell. Yes, I set it up but I can't recall what that box is called. I want to edit it and for the life of me I can't remember the phrase to search for in Help to remember how I created it or how to edit it. Can someone remind me? Thanks.