Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell
 

Thank You for the las info, that was helpfull. I now need to apply the
colour and the contents from the referenced cell to the current cell,
preferably without
creating intermediate cells to achieve it. Only background colour and
content matters.