copying conditional formatting

Hi,
I have a row of 5 cells. I want to format them so that when two of the 5
cells are >0 the whole set of cells change color. I used the countif function
to do this and it works fine.

I now want to copy this conditional format for all 5 cells down the other 50
rows. I have tried the usual paste, paste special, but these do not work.

Any help would be appreciated

Thank you

David Williams

demechanik
Sat Mar 15 07:39:01 CDT 2008

Try the format painter (brush icon)
Select the row of 5 cells with CF
Double click on the format painter
Then just "brush" over (select) the 50 rows below
Press Esc when done
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zzdave" wrote:
> Hi,
> I have a row of 5 cells. I want to format them so that when two of the 5
> cells are >0 the whole set of cells change color. I used the countif function
> to do this and it works fine.
>
> I now want to copy this conditional format for all 5 cells down the other 50
> rows. I have tried the usual paste, paste special, but these do not work.
>
> Any help would be appreciated
>
> Thank you
>
> David Williams

SeanTimmons
Sat Mar 15 08:02:01 CDT 2008

By default, conditional formatting uses absolute values ($). If you want to
copy down rows, just remove the $ in front of the row number in your formulas.

$A$1 -> $A1

"zzdave" wrote:

> Hi,
> I have a row of 5 cells. I want to format them so that when two of the 5
> cells are >0 the whole set of cells change color. I used the countif function
> to do this and it works fine.
>
> I now want to copy this conditional format for all 5 cells down the other 50
> rows. I have tried the usual paste, paste special, but these do not work.
>
> Any help would be appreciated
>
> Thank you
>
> David Williams

zzdave
Sat Mar 15 17:25:02 CDT 2008

Thanks to both of you. Both systems work. Thanks again

"Sean Timmons" wrote:

> By default, conditional formatting uses absolute values ($). If you want to
> copy down rows, just remove the $ in front of the row number in your formulas.
>
> $A$1 -> $A1
>
> "zzdave" wrote:
>
> > Hi,
> > I have a row of 5 cells. I want to format them so that when two of the 5
> > cells are >0 the whole set of cells change color. I used the countif function
> > to do this and it works fine.
> >
> > I now want to copy this conditional format for all 5 cells down the other 50
> > rows. I have tried the usual paste, paste special, but these do not work.
> >
> > Any help would be appreciated
> >
> > Thank you
> >
> > David Williams

zzdave
Sat Mar 15 17:26:02 CDT 2008

Thanks, both systems work brilliant

"Max" wrote:

> Try the format painter (brush icon)
> Select the row of 5 cells with CF
> Double click on the format painter
> Then just "brush" over (select) the 50 rows below
> Press Esc when done
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "zzdave" wrote:
> > Hi,
> > I have a row of 5 cells. I want to format them so that when two of the 5
> > cells are >0 the whole set of cells change color. I used the countif function
> > to do this and it works fine.
> >
> > I now want to copy this conditional format for all 5 cells down the other 50
> > rows. I have tried the usual paste, paste special, but these do not work.
> >
> > Any help would be appreciated
> >
> > Thank you
> >
> > David Williams

Max
Sat Mar 15 18:41:46 CDT 2008

Welcome, thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zzdave" <zzdave@discussions.microsoft.com> wrote in message
news:A95D3D27-C64E-4D45-BEC7-FC38D68538BC@microsoft.com...
> Thanks, both systems work brilliant