Prev: I need to open a file in excel located on another computer
Next: how do you print odd numbered pages
From: htown on 18 Mar 2010 11:29
I have 1000 rows and 20 columns, and used the three variables in sort.

Is there a formula that will insert a bold line after a particular column
changes staying within the confines of the chart?
From: Pete_UK on 18 Mar 2010 13:31
A formula cannot return a line, bold or otherwise. You will need a
macro to do that.

Hope this helps.

Pete

On Mar 18, 3:29 pm, htown <ht...(a)discussions.microsoft.com> wrote:
> I have 1000 rows and 20 columns, and used the three variables in sort.
>
> Is there a formula that will insert a bold line after a particular column
> changes staying within the confines of the chart?

From: Bob I on 18 Mar 2010 16:55
What do you mean "changes staying within the confines of the chart"

As far as underlining a cell you can use conditional formatting.

htown wrote:

> I have 1000 rows and 20 columns, and used the three variables in sort.
>
> Is there a formula that will insert a bold line after a particular column
> changes staying within the confines of the chart?

 | 
Pages: 1
Prev: I need to open a file in excel located on another computer
Next: how do you print odd numbered pages