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

G

Guest

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Excel conditional formatting with Weeknum 4
Excel Conditioning Formatting 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copying Row Code Doesn't Copy Conditional Formating 10
Copying conditional formatting to entire sheet 3
recognizing conditional formatting with VBA 3
Conditional Formatting with VBA 4

Top