conditional formatting
 

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

conditional formatting
 

hi
formating cannot change data nor delete data. it can only change the way
data looks on the sheet.
so change the way the date looks by setting it's font color to the same
color that you changed the cell to.

Regards
FSt1

"joe@malvern" wrote:

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

conditional formatting
 

thanks for your help

"joe@malvern" wrote:

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