copying conditional formatting

[zzdave]

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]

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

 

[Sean Timmons]

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]

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

 

[zzdave]

Thanks, both systems work brilliant

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]

Welcome, thanks for posting back.