Copying Conditional Format

[Marie]

Trying to find easiest way to copy a certain conditional
format that will work in a range of cells.

I want to say if cell C6 equals a certain value, highlight
other cells in the same row. The formula below works, but
when I try to copy the condition to other rows using
Format Painter, it copies the absolute C6 cell reference,
even though there is no '$' in the formula. Result: all
rows use the absolute cell C6 in the condition, rather
than changing the reference for each individual row.

="AND(C6=""*L""),(C6=""*Z"")"

How do I get it to copy relative cell references only?

 

[Bob Phillips]

Marie,

Why not try

=AND(C6="*L",C6="*Z")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)