Copying Conditional Formatting

D

deluth

I am currently using Excel 2003. I have set a cell to have conditional
formatting based on the result of another cell. How can I copy this logic to
another cell - with the logic in the cells changing (like a formula)?

For example: color cell C4 red if A4 is 10
-> copy this to C5 with dependency on A5, and etc...
-> Basically, I want to color every cell in Column C red if the value in
Column A is 10 without going into every cell in the column and making the
dependency changes respectively.

Thanks in advance. Deluth.
 
G

Grant Jenkins

Hi,

When you setup the Conditional Formatting and select which cell you want to
reference, it automatically puts $ in front of the cell column letter and row
number e.g. =$A$2 If you remove the $ signs so it just says =A2, the it will
change the reference relative to where you move it.

So in the conditional formatting you would have "Cell Value Is" "equal to"
=A2, instead of =$A$2.

Hope this is clear.

Cheers,

Grant.
 
G

Grant

Hi again,

and to add... you would copy the first cell with the formatting, then use
Paste Special > Formats to just paste the format of the cell down/across to
the other cells.

Not sure if you needed this also :)
 
B

Biff

Hi!

You can do this in one operation. Just select the range of cells in column C
that you want to format and
use this formula:

=A4=10

The cell references will automatically increment in the other cells.

Select the range C4:C100
Goto Format>Conditional Formatting.
Formula is: =A4=10
Select your desired styles.
OK out.

Biff
 
G

Grant

Hi Biff,

Oops, I don't think I read the question right at the start... I thought we
were trying to compare values from one cell to another, and not all to 10.

Yours is right - Deluth... just ignore mine :p
 
Top