I have a dropdown menu in cell A1 that is either Yes or No.
I want cell C1 to display "Data Required" if A1 = Yes and is left blank
if A1 = No.
How do I program cell C1??


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=538860