Copy/paste style doesn't work for conditional formatting with cell refs

Every users get this behaviour.
A conditional format relying to a comparison against a given cell doesn't adjust the referenced cell when we copy paste it.

Don't worry, I often wrote : *_choose the tool matching your needs._*

Yvan KOENIG (VALLAURIS, France) jeudi 19 août 2010 12:56:49

Same Problem here.. is there a workaround yet?

On this point, Numbers does exactly what the engineers asked it to do.

Hoping to get a workaround to a designed feature is wasting your time.

You had 30 days to test Numbers for free and check if it was fitting your needs.
I repeat what I responded to the OP: *_if the tool doesn't match your needs, use an other one._*

Customer is a full time job.

Yvan KOENIG (VALLAURIS, France) jeudi 23 septembre 2010 14:31:17

Don't know if you'd consider this a 'workaround' or simply a way to do what the OP asks with as little fuss as possible.

I created a conditional format on a cell (B3) that compares its value to the value of a cell above it (B2).
If I 'Copy Style' and paste that style into the cell beside it (C3), the conditional formatting still refers to B2...

The desire is to have each cell in row 3 formatted depending on a comparison with the cell directly above it. If each comparison is the same (eg, Equal to), and the 'true' action for each is the same (eg. Fill with yellow), the following will save some effort:

Select the whole row, B3:G3 (or further).
Set the conditional format rule to
Equal to | B2
And the action for Fill yellow.
Click Done.

With the conditional formatting dialogue still open, select C3. You may also want to move the dialogue window up to just below row 3.


Repeat these three steps:

Click on the B2 reference in the dialogue.
Click on cell C2 in the table.
Press the right arrow to move the selection to D3.

Click on the B2 reference in the dialogue.
Click on cell D2 in the table.
Press the right arrow to move the selection to E3.

etc.

Regards,
Barry