Conditioned formatting

  • Thread starter Thread starter sgdgr
  • Start date Start date
S

sgdgr

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
 
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?
 
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
 
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
 
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..
 
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
 
Back
Top