|Subject:||Copy/Past Conditional Format|
|Posted by:||Ken (Kenneth.H.All…@pw.utc.com)|
|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