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

copying conditional formatting
 

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

copying conditional formatting
 

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

copying conditional formatting
 

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

copying conditional formatting
 

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

copying conditional formatting
 

Welcome, thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zzdave" wrote in message
...
Thanks, both systems work brilliant