G
Guest
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
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