IN cell C1 put this formula............

=IF(A1="yes","Date required","")

Vaya con Dios,
Chuck, CABGx3



"SteveG" wrote:


=IF(A1="Yes","Data Required","")

This assumes that A1 will always be "Yes" , "No" or blank.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=538860