Hi,

Windows XP fully updated
Excel 2002 sp3

is there a way to make a cell's background colour change depending upon
the contents for ANOTHER cell.

E.G.

if cell A1 contains the word 'done' I would like the background colour
of B1 to be yellow.

Conditional formatting only seems to work on the cell in question not on
another cell.

Thanks

--
Nospam