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 _______________________________________________ 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/4820e24b-59c9-46c9-a8d2-c1981385f...@information-architecture.com ** 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.
