View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
edvwvw via OfficeKB.com edvwvw via OfficeKB.com is offline
external usenet poster
 
Posts: 79
Default Display contents of associated cells

If ( rule B2 = True,C2,"something else")

Don wrote:
Hi,

If I have a rule in (say) cell B2 to deliver a a specific piece of
information, how would I consider composing an alternate rule that displays
the content of another cell aligned with it eg if(ruleB2=TRUE) then display
contents of C2 ...

Does that make sense ;(

Don-


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200807/1