I have a conditional format based on this formula:

="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"

How do I copy this conditinal format to other cells and have the cell
reference change to the appropriate cell address. If I just copy the format,
using the format painter, it does not update the cell reference!

Jan

I maybe should add, that I cant just coipy the cell, as the cells, that
should use the conditional format already contains different formulas. The
only thing they have in common is that they create a date.

Jan
"sgdgr" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I have a conditional format based on this formula:
>
> ="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"
>
> How do I copy this conditinal format to other cells and have the cell
> reference change to the appropriate cell address. If I just copy the
format,
> using the format painter, it does not update the cell reference!
>
> Jan
>
>
>

What are the quotes for? It works for me using the format painter (as I
would expect),
maybe the cell where you copy the format to isn't a numeric?

--

Regards,

Peo Sjoblom


"sgdgr" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I have a conditional format based on this formula:
>
> ="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"
>
> How do I copy this conditinal format to other cells and have the cell
> reference change to the appropriate cell address. If I just copy the
format,
> using the format painter, it does not update the cell reference!
>
> Jan
>
>
>

I put the quotes here by mistake, they are not in the actula spreadsheet,
but even without them, I cant get it to work When I use the format painter
to paint the format on another cell, it still refers to A1, not fx C17. And
yes, the cell IS numeric, or rather contains a formula with a numeric
output.

Jan

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What are the quotes for? It works for me using the format painter (as I
> would expect),
> maybe the cell where you copy the format to isn't a numeric?
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "sgdgr" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > I have a conditional format based on this formula:
> >
> > ="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"
> >
> > How do I copy this conditinal format to other cells and have the cell
> > reference change to the appropriate cell address. If I just copy the
> format,
> > using the format painter, it does not update the cell reference!
> >
> > Jan
> >
> >
> >
>
>

Sorry, got it working now. Almost. Now I can copy the conditional format and
have it change cell reference. I dont know what error i made before, but
anyway it works.

Now I just have created another problem. The Format painter copis all format
to the next cell, but I only need to copy the conditional formatting. Is
there any way to circumvent thus problem?

Jan


"sgdgr" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I put the quotes here by mistake, they are not in the actula spreadsheet,
> but even without them, I cant get it to work When I use the format painter
> to paint the format on another cell, it still refers to A1, not fx C17.
And
> yes, the cell IS numeric, or rather contains a formula with a numeric
> output.
>
> Jan
>
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > What are the quotes for? It works for me using the format painter (as I
> > would expect),
> > maybe the cell where you copy the format to isn't a numeric?
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "sgdgr" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > I have a conditional format based on this formula:
> > >
> > > ="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"
> > >
> > > How do I copy this conditinal format to other cells and have the cell
> > > reference change to the appropriate cell address. If I just copy the
> > format,
> > > using the format painter, it does not update the cell reference!
> > >
> > > Jan
> > >
> > >
> > >
> >
> >
>
>

If I put a formula that will return a date in A1, then use the same formula
in conditional formatting,
then select the cell, click the format painter, click on for instance C1,
then the format formula will
change from A1 to C1 as in

=OR(WEEKDAY(C1)=6;WEEKDAY(C1)=7)


of course if you are using absolute references

=OR(WEEKDAY($A$1)=6,WEEKDAY($A$1)=7)

then it won't change..



--

Regards,

Peo Sjoblom


"sgdgr" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I put the quotes here by mistake, they are not in the actula spreadsheet,
> but even without them, I cant get it to work When I use the format painter
> to paint the format on another cell, it still refers to A1, not fx C17.
And
> yes, the cell IS numeric, or rather contains a formula with a numeric
> output.
>
> Jan
>
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > What are the quotes for? It works for me using the format painter (as I
> > would expect),
> > maybe the cell where you copy the format to isn't a numeric?
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "sgdgr" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> > > I have a conditional format based on this formula:
> > >
> > > ="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"
> > >
> > > How do I copy this conditinal format to other cells and have the cell
> > > reference change to the appropriate cell address. If I just copy the
> > format,
> > > using the format painter, it does not update the cell reference!
> > >
> > > Jan
> > >
> > >
> > >
> >
> >
>
>

I got it working now. Thanks.

Is the a way to solve my other problem, copying only the conditional format,
not the other format in the cell?

Jan


"Peo Sjoblom" <(E-Mail Removed)> skrev i en meddelelse
news:(E-Mail Removed)...
> If I put a formula that will return a date in A1, then use the same
formula
> in conditional formatting,
> then select the cell, click the format painter, click on for instance C1,
> then the format formula will
> change from A1 to C1 as in
>
> =OR(WEEKDAY(C1)=6;WEEKDAY(C1)=7)
>
>
> of course if you are using absolute references
>
> =OR(WEEKDAY($A$1)=6,WEEKDAY($A$1)=7)
>
> then it won't change..
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "sgdgr" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I put the quotes here by mistake, they are not in the actula
spreadsheet,
> > but even without them, I cant get it to work When I use the format
painter
> > to paint the format on another cell, it still refers to A1, not fx C17.
> And
> > yes, the cell IS numeric, or rather contains a formula with a numeric
> > output.
> >
> > Jan
> >
> > "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > What are the quotes for? It works for me using the format painter (as
I
> > > would expect),
> > > maybe the cell where you copy the format to isn't a numeric?
> > >
> > > --
> > >
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > >
> > > "sgdgr" <(E-Mail Removed)> wrote in message
> > > news:%(E-Mail Removed)...
> > > > I have a conditional format based on this formula:
> > > >
> > > > ="OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)"
> > > >
> > > > How do I copy this conditinal format to other cells and have the
cell
> > > > reference change to the appropriate cell address. If I just copy the
> > > format,
> > > > using the format painter, it does not update the cell reference!
> > > >
> > > > Jan
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>