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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TygerJ - 30 Mar 2005 21:15 GMT

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.

Reply to this Message

Gord Dibben - 31 Mar 2005 01:07 GMT

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

>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
[quoted text clipped - 3 lines]
>there is a value in the first cell the entire sheet changes color. Any ideas
>would be appreciated. Thanks.

Reply to this Message

Rate this thread: