Select the entire column, go into Format Conditional
Formatting and use:

=$A$7=1

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

A conditional formatting question i hope someone may be
able to help
me with.

Depending on the entry in cell A7, i.e. either 1 or 0,
cells A1 - A6
have conditional formatting applied to them ( in fact if
A7 = 1 then
the font colour in cells A1 - A6 is red)

My question is how can I copy this conditional
formatting down to say,
row 200?

The formatting is set by the following formula $A$1=1,
then font is
red

If I copy down, then I have to amend the formula for
each line,
incrementing by hand the value of column 7 - is there a
way to do this
automatically?

I am using Excel 2000 SP3


--
Cheers

Peter

Remove the INVALID to reply
.