On Mon, 29 Apr 2013 22:25:55 -0400, GS wrote:

'MyVeryOwnSelf[_3_ Wrote:
;1611510'] I am using a formula for a conditional format, but
when I copy it done -
to other rows using format painter the formula does not change. -
- The formula is =AND(A10<"Paid",C10<"",C10<today())

I am trying to highlight dates which have past and are unpaid.-

For me (with Excel 2010) CF and format painter work the way you
expect it to.

I put the CF in C10 and painted it onto C1:C37.

Sure, when looking at the formula using
Home Styles Condtional formatting
the formula doesn't change on the screen, but since it applies to
$C$1:$C$37 and the formula includes a relative row numbers A10 &
C10 (without $), the effect does propagate the way you want.

I don't understand why you get different results. Maybe there are
extra spaces or something in the "Paid" cells.

Thanks I'll give it a go at work tomorrow. I hve always copied cf's
with painter before and it has worked.
I think because I was randomly checking the cf in different cells I
was confused as to why the formula hadn't changed. On previous cf's
I have done the formula has moved to take into account the
row/cell I am viewing it from.
Perhaps it is me overthinking it! Thanks for your help.

Must be an overthinking day all around because I have no clue what I
was thinking. (I know full well how Format Painter works because I
use it all the time) Maybe I need some sleep, or coffee, because
you are quite right!

Painted yerself into a corner and didn't even know it, 'cause ya
got some in yer eye!

Haha! Some days that not so hard to do!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion