How to copy the format from one cell to another

[Closed]
Report
-
Hello,

I have a table SalesPeople (Code and Name). Every code is unique. I have added a colour on each code and name (each row).

Then I have another table Sold (Code, Qty, Item, Name).
Name is VLOOKUP( Sold:[Code];SalesPeople:[Code:Name];2;FALSE).
But I'd also like the colour from the table SalesPeople to be added to the line.

Is there a way to do that, so that I don't have to setup every colour in conditional formatting for the Sold-table?
Something like VLOOKUP([Code];[Code];<return an use the format>;FALSE)


Thanks in advance
Thomas