J
joe@malvern
column A column b
active 01/01/09
sold 02/01/09
active 03/02/09
If A2="sold" I can get the the cell in B2 to change color but how do I get
the date in column B to also change to "" at the same time?
thanks for your help
active 01/01/09
sold 02/01/09
active 03/02/09
If A2="sold" I can get the the cell in B2 to change color but how do I get
the date in column B to also change to "" at the same time?
thanks for your help