not sure what you mean by 'group' - there is an option under the data menu
called group & outline / group which is basically an alternative to hiding
columns? is this what you're after?
Grouping columns - look under the Data menu at Group and Outline
Comparing entries - if you want to highlight entries in column B that match
the entry for the same row in column A, use Conditional Formatting (on the
Format menu). First hihglight the values in column B, then select
Conditional formatting. Set 'Cell Value is' , then use 'equal to' and
finally, point to the adjoining cell in column A. Make sure the reference is
relative, i.e., has no $$ in it. Then set your format and OK your way out
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
