Copying Conditional Formatting

[Jason]

Hi,

I have a cell that has the following Conditional
Formatting formula:

=NOT(ISBLANK($A$6))

The condtional format is a border. So if the cell is
blank, no border. If the cell is not empty, border.

I want to copy this same conditional formula to several
other cells on my worksheet so that they behave in the
same manner as A6. However, any copy method I use (Paste
Special, Formats) keeps the cell reference of A6. So if I
copy this to A10, the border for A10 is controlled by
whether A6 is empty or not empty insteald of whether A10
is empty or not empty.

How do i copy this conditional formatting so that the
format is based upon the cell the formatting is copied to
and not A6?

Thanks.

 

[Frank Kabel]

Hi
change the formula to
=NOT(ISBLANK(A6))

you may check the Excel helpfile for relative/absolute references for
more information about this

 

[Josiah]

Nevermind...


(Edited for my own stupidity

 

[Guest]

Thank you, that worked.

Jason

-----Original Message-----
Hi
change the formula to
=NOT(ISBLANK(A6))

you may check the Excel helpfile for relative/absolute references for
more information about this

--
Regards
Frank Kabel
Frankfurt, Germany



.