Thread: Validation rule
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
nick
 
Posts: n/a
Default 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