LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Conditional Hyperlink (If statement?)


This is driving me nuts. There has to be a simple solution to this.
Somebody help me!

I want Excel to examine the contents of a cell (say "A1" and do one of
two things in cell "B1":

1. If "A1" contains a certain value, I want Excel to display a
hyperlink to a web site in "B1".

2. If "A1" does not contain this value, I want Excel to display
nothing at all in "B1".

Surely this is possible (and probably easy). Right??


--
clemson1994
------------------------------------------------------------------------
clemson1994's Profile: http://www.excelforum.com/member.php...o&userid=28225
View this thread: http://www.excelforum.com/showthread...hreadid=477762

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink in an IF statement martix Excel Worksheet Functions 2 June 7th 06 12:38 AM
Hyperlink in an IF statement. martix Excel Worksheet Functions 1 June 7th 06 12:19 AM
Conditional hyperlink? y_not Excel Discussion (Misc queries) 2 November 24th 05 04:02 PM
How can I use HYPERLINK in a conditional statement between sheets Mikey Excel Worksheet Functions 1 May 3rd 05 08:07 PM
Conditional Hyperlink? Mike Excel Programming 1 February 1st 05 01:04 AM


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"