View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Display contents of associated cells

=IF(B2=TRUE,C2,"whatever you want if B2 is FALSE") or merely
=IF(B2,C2,"whatever you want if B2 is FALSE")
--
David Biddulph

"Don" wrote in message
...
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-