On Tue, Mar 31, 2009 at 10:17 AM, Ken Kixmoeller/fh < [email protected]> wrote:
> > On Mar 31, 2009, at 12:06 PM, John Weller wrote: > > > I have just been teaching a class in Excel 2003. One of the students > > noticed that some of the cells had a green corner, similar to the > > red one > > that means a cell has a comment. I was asked what it meant but > > couldn't > > give an answer, nor could I find it in Help. Does anyone know the > > significance? I can't even reliably reproduce the behaviour but > > have seen > > it often before. > > The green corner indicates that there is something Excel considers a > potential problem based on adjacent cells. You can reproduce it > easily: Populate 3 columns with numbers and sum each column. Then, > "accidentally" alter the formula of _one_ of the sum cells from (for > example) =SUM(B1:B20) to =SUM(B1:B19). Since the formula differs from > the adjacent ones, you'll get the "green corner." > > You want to come to one of *my* Excel classes? <g,d&r> > > Ken > I've always noticed the green corner on cells that are formatted as text but contain a number. -- > Fred > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
