Copy/Past Conditional Format

Giganews Newsgroups
Subject: Copy/Past Conditional Format
Posted by:  Ken (Kenneth.H.All…
Date: Thu, 9 Oct 2003

Good morning board ... :)

Presently, I have approx 15 rows by 100 columns loaded
with Conditional formatting ... working ok so far.

Now I need to extend this same pattern down ... maybe
skipping a couple of rows between each pattern.

Issue ... Conditional format formulas are not changing
when I do copy/paste due to $ locking the cell positions.
And if I take the $ out ... then Conditional format
appears to fail where they already exist.

I am certain this can't be unique, but I do not know the
fix or work around ... Therefore, I am coming to the many
Magicians of this board ... Thanks ... Kha