How do I copy a conditional format that uses a formula in a serie.

[TygerJ]

I have an Excel spreadsheet in which I set up a conditional format that
changes the color of an entire row when one of the cells has a value greater
than 0. I want to copy this format throughout the sheet. I can't find a way
to do it except by formatting each row individually. Every way that I've
tried does not allow the formula to be in a series which means that when
there is a value in the first cell the entire sheet changes color. Any ideas
would be appreciated. Thanks.

 

[Gord Dibben]

Tyger

Assuming you want to CF rows 1:100 depending upon a value in each cell in
column A

Select all the rows to format.

Under Formula is: enter =$A1>0

You may be running into problems with an Absolute address like =$A$1 which
will always look at A1 and format all rows if A1 >0


Gord Dibben Excel MVP