Is there any formulas so I can colour a cell in a particular colour in one
workbook and have the colour also appear in a particular cell in another
workbook?

The short answer is No. A formula can only return a value to the cell
in which it is located - it cannot change the format (colour), nor can
it "push" a result to another cell.

Pete

On Aug 1, 11:46 pm, Man wrote:
Is there any formulas so I can colour a cell in a particular colour in one
workbook and have the colour also appear in a particular cell in another
workbook?

thank you for letting me know

"Pete_UK" wrote:

The short answer is No. A formula can only return a value to the cell
in which it is located - it cannot change the format (colour), nor can
it "push" a result to another cell.

Pete

On Aug 1, 11:46 pm, Man wrote:
Is there any formulas so I can colour a cell in a particular colour in one
workbook and have the colour also appear in a particular cell in another
workbook?

You're welcome - sorry the answer couldn't be Yes.

Pete

On Aug 2, 1:58 am, Man wrote:
thank you for letting me know



"Pete_UK" wrote:
The short answer is No. A formula can only return a value to the cell
in which it is located - it cannot change the format (colour), nor can
it "push" a result to another cell.

Pete

On Aug 1, 11:46 pm, Man wrote:
Is there any formulas so I can colour a cell in a particular colour in one
workbook and have the colour also appear in a particular cell in another
workbook?- Hide quoted text -

- Show quoted text -

On Aug 2, 4:06 am, Pete_UK wrote:
You're welcome - sorry the answer couldn't be Yes.

Pete

On Aug 2, 1:58 am, Man wrote:



thank you for letting me know

"Pete_UK" wrote:
The short answer is No. A formula can only return a value to the cell
in which it is located - it cannot change the format (colour), nor can
it "push" a result to another cell.

Pete

On Aug 1, 11:46 pm, Man wrote:
Is there any formulas so I can colour a cell in a particular colour in one
workbook and have the colour also appear in a particular cell in another
workbook?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Yes You can't "push" a value or format, but you can "pull" it.
Whatever caused the change in color of the first cell was triggered
by
a conditional formatting condition or formula. That criteria can
cause
a change in a cell on the second worksheet by writing a formula in
the
2nd worksheet cell that duplicates the action of the original CF
formula or condition. Conditinal formatting can then be applied to
the desired cell in the 2nd worksheet (CF is confined to same
worksheet values hence the need of a "bridging " formula==which
wouldn't be required if it was on the same worksheet). I could
illustrate if you could provide the original cell condition or
formula, and the initial CF.

ed

And if the colour was manually applied to the first cell? The OP said:

... so I can colour a cell in a particular colour ...

Why did you repeat your post 12 hours later? I saw your first one.

Pete

On Aug 3, 6:28 pm, ed wrote:

Yes You can't "push" a value or format, but you can "pull" it.
Whatever caused the change in color of the first cell was triggered
by
a conditional formatting condition or formula. That criteria can
cause
a change in a cell on the second worksheet by writing a formula in
the
2nd worksheet cell that duplicates the action of the original CF
formula or condition. Conditinal formatting can then be applied to
the desired cell in the 2nd worksheet (CF is confined to same
worksheet values hence the need of a "bridging " formula==which
wouldn't be required if it was on the same worksheet). I could
illustrate if you could provide the original cell condition or
formula, and the initial CF.

ed

On Aug 1, 5:46 pm, Man wrote:
Is there any formulas so I can colour a cell in a particular colour in one
workbook and have the colour also appear in a particular cell in another
workbook?

Yes You can't "push" a value or format, but you can "pull" it.
Whatever caused the change in color of the first cell was triggered by
a conditional formatting condition or formula. That criteria can cause
a change in a cell on the second worksheet by writing a formula in the
2nd worksheet cell that duplicates the action of the original CF
formula or condition. Conditinal formatting can then be applied to
the desired cell in the 2nd worksheet (CF is confined to same
worksheet values hence the need of a "bridging " formula==which
wouldn't be required if it was on the same worksheet). I could
illustrate if you could provide the original cell condition or
formula, and the initial CF.

ed