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?