Hi,

I've got a spreadsheet that has conditional formatting so the the fill
colour of a cell goes Red, 'Amber' or Green dependant on the outcome of
certain formulae. The formulae work fine but the 'amber' colour turns brown
if I have 2 different spreadsheets open or if someone opens the file on a
different machine. Any ideas whats causing this?