Hi John, http://openoffice.blogs.com/openoffice/2008/05/copying-only-th.html
The link above will take you to a blog that explains how to achieve #2. As someone else pointed out, for #1, check the help for conditional formatting . tc >________________________________ > From: John Meyer <[email protected]> >To: [email protected] >Sent: Saturday, February 11, 2012 10:52:46 AM >Subject: [users] Looking for a couple of functions in Calc > >1. (noob alert). I'm looking for a function where I can check a particular >cell for text and color the cell based upon that value. >2. I'm also looking for a function that can either list the unique values in >a column, or the count of unique values in a column. >-- ----------------------------------------------------------------- >To unsubscribe send email to [email protected] >For additional commands send email to [email protected] >with Subject: help > > >-- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
