texaslonghorn
New member
- Joined
- May 30, 2011
- Messages
- 8
- Reaction score
- 0
- Points
- 0
Hi all. Disclaimer - please bear with me, I ain't too smart and am a real beginner with excel, so my questions may cause severe "eye rolling" to occur...
I am using excel 2011 for Mac and am trying to get a range of cells (for ease of discussion, call them A5 through B16 to become shaded if C4="N". The purpose here is to grey out a range of cells if the user answers "N" to the question about the applicability of the section.
Similarly, if C4="N", is it possible for rows 5 through 15 to collapse or somehow else be hidden - but not deleted, with rows 16 and beyond shifting up?
Thanks for all the help...
I am using excel 2011 for Mac and am trying to get a range of cells (for ease of discussion, call them A5 through B16 to become shaded if C4="N". The purpose here is to grey out a range of cells if the user answers "N" to the question about the applicability of the section.
Similarly, if C4="N", is it possible for rows 5 through 15 to collapse or somehow else be hidden - but not deleted, with rows 16 and beyond shifting up?
Thanks for all the help...