Posted to microsoft.public.excel.misc
|
|
Validation rule
Thanx a lot
"EdMac" wrote:
Hi Nick
In Ws2 A1
=IF(WS1!A1<"",value,"")
this will put in a value you define if not blank otherwise it will be
blank
Ed
--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=519363
|